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.

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.

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:

Set up Power BI Connector in NodeGraph

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.

1. Click Test to test the connection.

2. Save.