Connection to PowerBI

image_pdfimage_print

This component defines a connection to the business analytics service Power BI provided by Microsoft.

For this connection a “Power BI Connector License” is required.

Main settings

Azure Application ID

The application ID in Azure Active Directory (also called 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.

Username

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.

Note:
In order to connect to a Power BI instance from Jedox you have to create an application in Azure Active Directory or directly from the this link https://dev.powerbi.com/apps. The application type must be client-native. After completion of this process, the user can see the automatically created Client ID on the same page. The next step is to grant application permissions. This process can only be done by a global Azure administrator or domain members which have required Azure permissions. For more information see here: https://docs.microsoft.com/en-us/azure/active-directory/active-directory-integrating-applications
The access token, refresh token and all authentication are handled automatically by the PowerBI connection.

 

image_pdfimage_print
Was this post helpful?
NoYes (-3 rating, 3 votes)
Loading...