Contents

How to embed Microsoft Power BI Reports in DNN Applications

Guide to embed Power BI reports, dashboards in DNN. Integrate Microsoft Power BI with DNN using miniOrange embed Power BI DNN plugin. This setup guide will demonstrate the steps on how to embed Power BI reports, dashboards, tiles, datasets / semantic model in DNN pages and posts so users can view the interactive Power BI artifacts from the DNN site itself. You can also enable row level security(RLS) for a granular view of the Power BI charts in DNN.

Pre-requisites : Download And Installation

To configure and embed Microsoft Power BI reports on your site you would need following pre-requisites:

Download our plugin DNN Power BI Integration - embed Power BI reports
You will need Azure AD global administrator access.

Click on the below tabs for Azure AD Steps & Power BI steps

1. Steps to configure Azure AD for DNN Power BI Integration

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.

DNN Power BI Embed with row level security | New registrations

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.

DNN Power BI Embed with row level security | Register registrations

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.

DNN Power BI Embed with row level security | Endpoints

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.

DNN Power BI Embed with row level security | Client secret

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

DNN Power BI Embed with row level security | 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.

DNN Power BI Embed with row level security | Add a permission

Select Microsoft Graph under the Microsoft APIs tab.

DNN Power BI Embed with row level security | Request api permissions

Select Application Permissions and search for the User.

DNN Power BI Embed with row level security | Select application permission

DNN PowerBI Embed with row level security | Select permission

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

DNN Power BI Embed with row level security | Readall Permission

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

DNN Power BI Embed with row level security | Power BI Permission

Select Delegate Permission and search for the Report

DNN Power BI Embed with row level security | Power BI Delegate Permission

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

DNN Power BI Embed with row level security | Power BI ReadAll Permission

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

DNN Power BI Embed with row level security | All Permissions

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

DNN Power BI Embed with row level security | Grant admin concent

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.

DNN Power BI Embed with row level security | Click on Add New

Click on New Group to add a new security group.

DNN Power BI Embed with row level security | Add shortcode

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.

DNN Power BI Embed with row level security | Add Workspace_ID

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

DNN Power BI Embed with row level security | visit powerbi report

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.

2. Steps to configure the Power BI settings

Configure Power BI Settings

Go to the Power BI dashboard and login as an administrator.
You will be represented with the home screen of the Power BI.
On the top right corner, click on settings icon as shown below.

DNN Power BI Embed with row level security | settings icon

Under the governance and insights click on the admin portal option.

DNN Power BI Embed with row level security | click on admin portal

In the admin Portal section, under the tenant settings, scroll down to the developer settings.
Click on Allow service principals to use Power BI APIs.
Enable the toggle and then click on Apply.

DNN Power BI Embed with row level security | Enable the toggle

Scroll down to the Admin API settings, enable the toggle and then choose the option of specific security groups.
Search for DNN Power BI User Group then click on Apply.

DNN Power BI Embed with row level security | Allow Power BI admin APis

Navigate back to the home page. Select the Workspaces tab from the left pane and then select your workspace from the list.

DNN Power BI Embed with row level security | Select Workspaces

Navigate to the Manage Access tab.

DNN Power BI Embed with row level security | Navigate to manage access tab

In the Manage Access section, click on the add Add People or Groups

DNN Power BI Embed with row level security | Add people or groups option

Search for the application that you have previously configured. From the dropdown select the Member and click on Add button to assign this Azure AD application to your Power BI workspace.

DNN PowerBI Embed with row level security | Select dropdown option

Select the report that you want to embed in DNN page or post.
Then copy the Workspace_ID and Report_ID from the URL as shown in the below image and keep it handy as you will need it further.

DNN Power BI Embed with row level security | Copy the IDs

Steps to configure the Power BI report into DNN site

3. Add module on DNN site

Open any of the page on your DNN site (edit mode) and click on Add Module.

DNN Power BI Embed with row level security | Add Module

Search for miniOrange Power BI Integrator and click on the DNNSAMLSSO. Drag and drop the module on the page where you want.

DNN Power BI Embed with row level security | Search module

You have finished with the installation of the module on your DNN site.

4. Embed your Power BI report into the DNN

Now go to your dnn site you can see that module is added successfully.

DNN PowerBI Embed with row level security | Module Added successfully

Click on the settings icon and go to settings

A window will popup go to the miniOrange Power BI Integrator Settings tab.

DNN PowerBI Embed with row level security | miniorange powerbi integrator settings tab

Go to the Authentication Settings tab and enter Client ID,Client Secret & Tenant ID of your Azure AD Application then click on save.

DNN Power BI Embed with row level security | authentication settings

Now go to Power BI settings tab and enter the Report name,Workspace_ID and Report_ID of your report.
Also enter the width and height and click on generate script.

The script will be generated which shows Workspace_ID and Report_ID of your Power BI report.

Refresh your DNN site and click on the Power BI sign-in button.

It will redirect you to Azure AD login page. Enter your Azure AD credentials

After successful login the Power BI report will be appear on the screen.

You have successfully embedded your PowerBI report into the DNN page and provided access to the Power BI report via Azure AD SSO .

Additional Resources

Need Help?

Mail us on dnnsupport@xecurify.com and we'll help you set up Power BI integration with your DNN and for quick guidance (via email/meeting) on your requirement and our team will help you to select the best suitable solution/plan as per your requirement.