# Microsoft Power BI Services

Power BI connectors are used to connect a Power BI environment.

## Prerequisites

NodeGraph uses a Master User to access Power BI resources. You will need to register a user in the Azure Active Directory, set it as Power BI service administrator and add access to all Power BI workspaces.

1. Register NodeGraph in Azure Active Directory

2. Apply permissions to your application within Azure AD

3. Set up Power BI Connector in NodeGraph

### Register NodeGraph in Azure Active Directory Using the Power BI Application Registration Tool:

1. Go to dev.powerbi.com/apps

2. Select Sign in with your existing account then select Next.

3. Provide an Application Name, i.e. NodeGraph

4. Select 'Native' as Application Type.

5. API Access select all Read only APIs.

6. Click register.

7. Save the Application ID.

Power BI application ID

Power BI application ID

Power BI application ID ![The application ID that appears after an application has been registered.](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-19.png)

### Apply permissions to NodeGraph within Azure AD

1. Browse to App registrations within the Azure portal and select the app that you're using for embedding.

2. Select API permissions under Manage.

3. Within API permissions, select Add a permission, then select Power BI Service.

Power BI API Permissions

Power BI API Permissions

Power BI API Permissions ![Add a permission at the top left of the screen, and Power BI Service at the bottom right.](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-20.png)

1. Add all read APIs under Delegated Permissions. Select them one by one to save the selections. Select Save when done.

2. Select Grant Consent.

The Grant Consent action is needed for the master account to avoid being prompted for consent by Azure AD. If the account performing this action is a Global Admin, you grant permissions to all users within your organization for this application. If the account performing this action is the master account and is not a Global Admin, you grant permissions only to the master account for this application. Note: Grant Consent may take some time. Check permissions in Azure App Registration under API Permissions:

Power BI consent granted

Power BI consent granted

Power BI consent granted ![A list of all Power BI permissions and whether they require consent.](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-21.png)

### Set up Power BI Connector in NodeGraph

[](https://help.qlik.com/en-US/nodegraph/Content/NodeGraph/Documentation/Using_NodeGraph/NodeGraph_Connectors/Microsoft_Power_BI_Services.htm)

#### Full list of connector fields

Add powerbi\_service connector

| Field | Default Input |
| --- | --- |
| SYSTEM ID | Id |
| SYSTEM NAME | Name |
| DESCRIPTION | Description (optional) |
| CONNECTOR TAGS | Tag1; Tag2; ... |
| CLIENT ID | None |
| USER | None |
| PASSWORD | None |
| SERVER NAME | mssql01-prod |
| FULLY QUALIFIED DOMAIN NAME | mssql01-prod.company.com |
| IP | 123.456.789.123 |
| DNS NAME | mssql01-prod.company.com;mssql02-prod.company.com; |

1. In NodeGraph, go to Settings -> Connectors -> New Connector.

2. Add a new Microsoft Power BI Services Connector and add Client ID (Application ID), User and Password.

Add Power BI credentials

Add Power BI credentials

Add Power BI credentials ![A sample set of Power BI credentials](https://help.qlik.com/en-US/nodegraph/Content/Resources/Images/NodeGraph/ui-NodeGraphTD-23.png)

1. Click Test to test the connection.

2. Save.