PowerBI Connection

image_pdfimage_print

This component defines a connection to the business analytics service Power BI provided by Microsoft. To use Power BI, you must have an active subscription to Office 365 with Power BI and a Power BI license From Jedox.

Connecting to Power BI

To connect to a Power BI instance from Jedox, you must first create an application (app) in Azure Active Directory (Azure AD). This can be done from one of the following Microsoft links: 

The application type must be native/client-native. To access Power BI, the required delegated permissions for the API “Power BI Service” must be assigned to this app. In the registered app, the permissions must be granted to each account either by the individual user or by an admin.

  1. Logon to the Microsoft Azure portal using one of the links above and navigate to Azure Active Directory→App Registrations→New Application Registration.

  2. At the next screen, you can create the application. Give it a name, select “Native” for Application type, and set the sign-on URL to http://localhost (this sign-on URL is not used with native apps). Click Create.

  3. At the next screen, click on Settings and select Required Permissions. Click Add.
  4. Under Add API access, select “Power BI Service” as the API. If “Power BI Service” is not on the list, then you probably don’t have a license for it.
  5. At the next screen, select all Delegated Permissions except those that require admin consent (see screenshot below). Click Select, then click Done.

  6. Click Grant Permission at the top of the Required Permissions screen. Click Yes to grant the permissions for the new app.

  7. For your Power BI connection, use the Application ID (Client ID), which can be seen in the application properties, highlighted below:

Main Settings

Azure Application ID:

The application ID in Azure Active Directory (also called App ID or Client ID)

Group Name:

Name of the Power BI group. The group’s workspace will be the target of Power BI loads. If no group is specified, the default workspace of the user is used.

User Name:

Power BI user name (Microsoft Office 365 user name).

Password:

Power BI user password.

Advanced Settings

SSL Mode:

Verify: the certificate is verified.
Trust: the certificate is imported to the keystore if not yet available.
Off: no SSL used.

For more information, see https://docs.microsoft.com/en-us/azure/active-directory/active-directory-integrating-applications.

 

image_pdfimage_print