Show/Hide Toolbars

Thereforeā„¢ Help

Tutorials > Solution Designer > Design > Reporting > Power BI

Set up integration with Microsoft Power BI in the Azure portal

Scroll

Configuration in Microsoft Entra ID

note

Permissions in the Azure portal

Please note that no delegated permissions or application permissions need to be added for the Microsoft Entra application created in this step. These permissions are not required for the application to function, and they may cause errors.

 

1.Go to the Azure portal and select 'Microsoft Entra ID'. The Azure portal can be accessed using the following link: https://portal.azure.com/#home

SD_T_Reports_PowerBI_azure_001

2.You will be taken to the Overview page for your Microsoft Entra ID tenant. Make a note of the Tenant ID. This ID is needed for setting up the integration with Microsoft Power BI in Thereforeā„¢.

SD_T_Reports_PowerBI_azure_025

 

3.Select 'App Registration' from the menu on the left and click 'New registration'.

SD_T_Reports_PowerBI_azure_002

4.Enter a name for your application, select the Supported account types, and enter a redirect URL, if needed. Click 'Register' to proceed.

SD_T_Reports_PowerBI_azure_003

5.Make a note of the 'Application (client) ID' in the Overview section. This ID can be reviewed by selecting the application under 'App registrations' > 'All apps'. It is needed for setting up the integration with Microsoft Power BI in Thereforeā„¢.

SD_T_Reports_PowerBI_azure_004

6.  Select 'Certificates & secrets' and click 'New client secret' to create a secret for the application. The 'Add a client secret' dialog will open.

SD_T_Reports_PowerBI_azure_010

7.  Enter a description for the client secret and set an expiration date. We recommend using 24 months so you donā€™t need to update the secret too often. If the secret expires the integration will stop working so make sure you update the secret before it expires. Click the 'Add' button to proceed.

SD_T_Reports_PowerBI_azure_011

8.  Copy and save the client secret's 'Value'. It is needed for setting up the integration with Microsoft Power BI in Thereforeā„¢. The client secret will not be accessible again after this window is closed.

SD_T_Reports_PowerBI_azure_012

9.  Go to Microsoft Entra ID > Groups and select 'New Group'.

SD_T_Reports_PowerBI_azure_013

10.  Go to Microsoft Entra ID > Groups and select the group you created. Click 'Members'.

SD_T_Reports_PowerBI_azure_015

11.  Click 'Add members'. The Add members dialog will open. Select the 'Enterprise applications' tab and check the application you created. Click the button labeled 'Select' to proceed.

SD_T_Reports_PowerBI_azure_016

12.  The application will now be listed as Service Principal.

SD_T_Reports_PowerBI_azure_018

Configuration in Microsoft Power BI

13.  Log into Microsoft Power BI as administrator and enable access by service principals. The setting can be found under: Settings > Admin Portal > Tenant settings > Developer settings > Allow service principals to use Power BI APIs. Under 'Apply to', add the security group you have created for your application in the previous step. Power BI can be accessed using the following link: https://app.powerbi.com/

SD_T_Reports_PowerBI_azure_019

14.  Select 'Workspaces' and create a new workspace or access an existing workspace. Click 'Manage Access' to open the Manage Access dialog.

SD_T_Reports_PowerBI_azure_020

15.  In the Manage Access dialog, click the button labeled 'Add people or groups' to open the 'Add people' dialog. Search for and check the application you created. Select 'Admin' from the dropdown menu. Click 'Add' to proceed.

SD_T_Reports_PowerBI_azure_021

16.  Extract the workspace ID from the URL. This ID is needed for setting up the integration with Microsoft Power BI in Thereforeā„¢.

SD_T_Reports_PowerBI_azure_022

Configuration in the Thereforeā„¢ Solution Designer

17.  In the Thereforeā„¢ Solution Designer, right-click on Power BI and select 'Settings'.

SD_T_Reports_PowerBI_azure_023

18.  Enter the Tenant ID, Application (Client) ID, Client Secret, and Workspace ID.

SD_T_Reports_PowerBI_azure_024

19.  Continue by sending data to Power BI to create reports.

Tutorial: Creating Reports