How to embed Microsoft Power BI Reports in DNN Applications

1. Configure the Azure AD app registration

• Log in to Azure AD portal as admin
• You will be presented with the home screen of azure active directory.
• Under the azure services section, select Microsoft Entra ID.


• In the left tab, under the manage section, select App registrations.


• Click on new registration.


• Assign the Display Name in the name field and choose the account type.
• In the Redirect URI field, provide the URL of your DNN site and click on the Register button.

• After the registration of an application, Azure AD assigns an unique application ID to your application.
• Navigate to the Overview tab, in the left pane.
• Copy the Application ID and the Directory ID, this will be your Client ID and Tenant ID.

• From the left navigation pane, navigate to the Certificates & secrets tab.
• Click on new client secret. Enter the description and expiration time and click on the ADD option.

• Copy the value of Secret Key. This will be your Client Secret Key.

 Add API permissions to your Azure AD application:

• Go to API Permissions from the left navigation pane and click on add a permission option.

• Select Microsoft Graph under the Microsoft APIs tab.

• Select Application Permissions and search for the User.

• Under User select User.Read and User.Read.All permissions and click on the Add Permissions button.(microsoft graph)

• Click on add permission scroll down and select Power BI Service under request api permission option.



• Select Delegate Permission and search for the Report

• Under Reports select Report.Read.All permission and click on the Add Permissionbutton. (Power BI)



• Now you can see the all permissions in the api permission section

• Click on grant admin consent for default directory and click on Yes on grant admin consent confirmation.

• You have successfully configured the Azure AD application.

2. Configure the Azure AD security group settings

• In the Azure active directory home page, navigate to the Groups from the left pane.

• Click on New Group to add a new security group.

• Select the Group type as Security from the dropdown and enter the Group Name as Allow Power BI Admin APIs.
• Once you have entered the details click on the Create button to create a new security group.

• Search and select newly created security groups (Allow Power BI Admin APIs).

• Navigate to the Members tab from the left pane and click on Add Members.
• Now search for the application name you have previously configured and click on the select button.

You have successfully configured Azure AD app to achieve User Sync and Power BI integration into your DNN site.