How to Embed Power BI Dashboards on a WordPress Site?

Overview

Organizations that need to display Power BI data in WordPress require a reliable way to connect their Microsoft Power BI environment with their site, especially because WordPress doesn’t offer a native solution for this.

The miniOrange WordPress Power BI plugin helps you integrate Power BI dashboards, reports, tiles, and datasets directly into WordPress pages or posts.

In this setup guide, we walk you through connecting WordPress to Power BI, configuring Azure AD permissions, enabling Row Level Security (RLS), and generating shortcodes to publish your Power BI reports smoothly.

Download Plugin Pricing Plans Free Trial

Pre-requisites : Download And Installation

Before starting the Power BI WordPress setup, make sure you have the following in place:

• Azure AD Global Administrator access
• miniOrange Power BI Embed plugin installed on your WordPress site
• Power BI Pro or Premium account, depending on your embedding method

Configuration Steps

Step 1: Configure the Azure AD App registration

• Log in to the Azure AD Portal as an Administrator.
• The home screen of Azure Active Directory appears.
• Under the Azure Services section, click Microsoft Entra ID.

• In the left navigation pane, under the Manage section, click App registrations.

• Click New registration.

• Enter a display name in the Name field and select the appropriate account type.
• In the Redirect URI field, enter the URL of the WordPress site and click Register.

• After registration, Azure AD assigns a unique application ID to the application.
• Open the Overview tab in the left pane.
• Copy the Application ID and Directory ID. These are used as the Client ID and Tenant ID.

• In the left navigation pane, open Certificates & secrets tab.
• Click on New client secret, provide a description and expiration period, and then click Add.

• Copy the Secret Value displayed on the screen. This value will no longer be visible once the page changes, so save it in a secure location.

Note: Confirm that the copied value is the Client Secret Value, not the Secret ID, as shown in the image.

Add API Permissions to your Azure AD Application

• In the left navigation pane, open API Permissions, then click Add a permission.

• Select Microsoft Graph under the Microsoft APIs tab.

• Select Application Permissions and search for User.

• Under User, select User.Read.All, then click Add Permissions (Microsoft Graph).

• Click Add a permission again.

• Click Power BI Service.

• Select Delegated Permissions and search for Report.

• Under Report, select Report.Read.All, then click Add Permissions.

• Click Grant admin consent for Default Directory.

• In the pop-up window, click Yes.

• Refer to the image below to confirm that all configured permissions match the required settings shown in the example.

• Now in the Azure AD Portal, navigate to Home >> Users tab, then select a specific user from the list.
• In the user details pane, locate the User principal name (UPN) and Object ID. Keep these details for plugin testing. (You can also use your own office365 email in the UPN field.)

• The Azure AD application is now successfully configured.

Step 2: Configure the Power BI Dashboard

• Go to the Power BI dashboard and log in as an Administrator.
• The Power BI home screen appears.
• In the top-right corner, click the Settings icon.

• Under the Settings pane, click Admin portal.

• In the Admin Portal section, scroll to Tenant settingsand locate the Developer settings area.
• In the Tenant Settings section, under Developer settings, click Service principals can use Fabric APIs.

• Enable the toggle, select Apply to The entire organization, and then click Apply.

• Click Allow service principals to create and use profiles.

• Enable the toggle, select Apply to the entire organization, and then click Apply.

• Return to the Home page, select Workspaces from the left pane, and then select your workspace from the list.

• In the navigation bar, click Manage Access.

• When you click on Manage Access, you will be presented with a screen showing the current users and security groups having access to the workspace.
• Next, click Add people/groups, search for the Azure AD application created earlier, and select it to provide access.

Note: In the setup guide, the sample application name is Test_application; replace this with the actual name of the configured Azure AD application to grant access.

• After that, Select Admin from the dropdown list and click Add.

• Once the application is added, open the report that needs to be embedded in a WordPress page or post.
• Copy the Workspace_ID and Report_ID from the report URL (see image below), and keep them handy as they will be required later.

• Free
• Enterprise
• Capacity-Free Embed

Step 3: Configure and View Power BI Content using SSO

• Go to the Embed Power BI Reports plugin in your WordPress dashboard.
• Under the Manage Application tab, enter the following details:

Application ID	Paste the Application ID from Azure AD App.
Client Secrets	Paste the Client Secret from the Azure AD App.
Redirect URI	Enter the URL of your WordPress site.
Tenant ID	Paste the Directory ID from Azure AD App.

• To test the connection, enter a User Principal Name (UPN) or Object ID in the Test UPN/ID field and click Save.
• If the configuration is successful, the user attributes from Azure AD will be displayed.
• Now you can enable Azure AD SSO into WordPress so that the users in your organization can view the Power BI content.
• Enable the toggle Add a Single Sign-On button on the WordPress login page to activate Azure AD SSO for your organization’s users.

Step 3: Configure and View Power BI Content using Customer Flow

• Navigate to the Embed Power BI Reports plugin in the WordPress dashboard.
• Under the Manage Application tab, enter the following fields:

Application ID	Paste the Application ID from the Azure AD App.
Client Secrets	Paste the Client Secret from the Azure AD App.
Redirect URI	Enter the URL of your WordPress site.
Tenant ID	Paste the Directory ID from the Azure AD App.

• To test the connection, enter the UserPrincipalName (email) or Object ID in the Test UPN/ID field, then select Save followed by Fetch Attributes to load the user details.

• If the Azure AD connection is successful, the attribute window appears as shown below.

Step 3: Configure and View Power BI Content using Master User Flow

• Navigate to the Embed Power BI Reports plugin in the WordPress dashboard.
• Under the Manage Application tab, enter the following fields:

Application ID	Paste the Application ID from the Azure AD App.
Client Secrets	Paste the Client Secret from the Azure AD App.
Redirect URI	Enter the URL of your WordPress site.
Tenant ID	Paste the Directory ID from the Azure AD App.

• Now, perform a test connection:
• In the Test UPN/ID field, enter the UserPrincipalName (email) of a user with a valid Power BI license. This user will act as the master user.
• Click Save, then click Fetch Attributes to initiate the connection and retrieve user attributes.

• Once Fetch Attributes is clicked, a window will appear as shown below. Select the Microsoft account under which a valid Power BI account exists.

• If the connection is successful, the attribute window will appear as shown below, displaying the retrieved user attributes.

Step 4: Embed Power BI report into WordPress

• Navigate to the Embed Power BI tab in the plugin.
• In the Select resource type to Embed dropdown, choose the appropriate resource type.
• Enter the Workspace ID, Report ID, and define the Height and Width as per your requirement for the report.
• Click Generate Shortcode.

• After successful shortcode generation, view the shortcodes in the ShortCodes Generated section.
• Copy the shortcode by clicking the copy icon next to the generated shortcode.

Note: You can generate multiple shortcodes for embedding different reports across your WordPress site.

• To embed the report, click Add new page or Edit an existing page.

• In the page editor, click the + icon and search for the Shortcode block.

• Paste the copied shortcode, then click Publish/Update.

• To view reports on WordPress, users must initiate SSO from Azure AD.

• If a user is not logged in through Azure AD SSO, they will see a login notice inside the embed container.

Step 4: Embed Power BI report into WordPres

• Go to the Power BI tab in the plugin and click the Add icon (+).

• Enter the following details:

Report Name	Enter a name for the report.
Workspace ID	Copy from the Power BI workspace.
Report ID	Copy from the Power BI workspace.
Type	Select Report (default), Dashboard, or Tile.

• Under Select Embed Mode, specify how the report should be embedded:
• For Create/Edit mode, enter the Dataset ID.
• For View mode, leave the Dataset ID field empty.

• In the Report has access to section:
• Select the WordPress roles that should be allowed to view the embedded report.
• For example, if Administrator, Contributor, and Subscriber are selected, only users with these roles can view the report.
• This configuration applies only when you enable the Only Allow Logged In User Access option.

• To restrict report access to logged-in users, enable Only Allow Logged In User Access.
• To allow public access to the embedded report, keep this option disabled.

• (Optional) If Row Level Security (RLS) is configured in Power BI:
• Enable the RLS toggle.
• Enter the Dataset ID required for RLS-based filtering.

• (Optional) Toggle on Enable User Email Domain-RLS Mapping to apply RLS based on the domain of the user’s WordPress email address.

• (Optional) When using RLS with WordPress roles, map each relevant WordPress role to the corresponding RLS role name (as defined on the Power BI side).

• After completing the configuration, select Save.

• Copy the generated shortcode.

• Paste the shortcode into any WordPress page or post where the report should appear.

• Select Publish/Update for the page. Use Preview to review the embedded report.

Note: In this configuration, only data for Germany is visible because the Germany RLS role is mapped to the Administrator role, and the current user is logged in as an Administrator.

Step 4: Embed Power BI report into WordPres

• Navigate to the Power BI tab in the plugin and click the Add icon (+).

• Enable the toggle Embed a report using the Power BI master user to allow embedding using the master user credentials.

• Enter the following details:

Report Name	Enter a name for the report.
Workspace ID and Report ID	Copy both values from the Power BI workspace.
Type	Default is Report. Change to Dashboard or Tile if required.

• Under Select Embed Mode, choose how the report should be embedded:
• For Create/Edit mode, enter the Dataset ID.
• For Viewmode, the Dataset ID field can be left empty.

• In the Report has access to section, select the WordPress roles allowed to view the report. For example, selecting Administrator, Contributor, and Subscriber ensures that only users with these roles will have access.
• This setting is only applied if you enable the Only Allow Logged In User Access option.

• Enable Only Allow Logged In User Access if you want to restrict report access to logged-in users only else turn it off if you want to embed the report publicly.

• (Optional) If Row-Level Security (RLS) is configured in Power BI:
• Enable the RLS toggle.
• Enter the RLS Table Name: Specify the name of the table in your dataset that contains the RLS role mapping logic. For example: EmployeeData
• Enter the RLS Column Name: Provide the column name that contains the identifier used to filter the data (e.g., email, role, or user ID). For example: UserEmail
• Enter the Dataset ID for RLS-based filtering.

• (Optional) Enable Enable User Email Domain-RLS Mapping to apply RLS based on the WordPress user’s email domain.

• (Optional) Map WordPress roles to corresponding Power BI RLS role names defined in the dataset.

• Click Save to apply the configuration.

• Copy the Generated Report Shortcode.

• Paste the shortcode into any WordPress page or post where the report should appear.

• Click Publish/Update the page.
• Use Preview to verify the embedded report.

Note: In this configuration, only data for France is visible because the France RLS role is mapped to the Administrator role, and the currently logged-in user has Administrator access.

Power BI is now successfully connected with WordPress, enabling the embedding of interactive reports, charts, and dashboards. With row-level security enabled, data can be filtered based on user roles or email domains, allowing for secure and granular data access.

Step 5: Additional configurations for your Embedded Resources

• To further customize the embedded Power BI content, navigate to the Settings tab in the plugin and configure the following options:

• Filter Pane : Enables or disables the display of the filter pane in the embedded report.
• Page Navigation : Enables or disables the page navigation bar shown below the report.
• Language : Sets the display language for the embedded content.
• Format Locale : Adjusts locale-specific formatting, such as numbers and dates.
• Mobile Breakpoint : Defines the screen width at which the report switches to a mobile layout. Any width below this value activates the mobile view.
• Mobile Height : Sets the height of the report when displayed in the mobile layout.
• Mobile Width : Sets the width of the report when displayed in the mobile layout.

These settings can be configured as required to suit different display needs and user environments.

Power BI is now successfully connected to WordPress, with Azure AD SSO enabled for your embedded reports. This configuration ensures that users access Power BI content based on their assigned roles, keeping everything aligned with your organization’s permissions. If you run into any issues during setup or integration, the support team is available at info@xecurify.com to help.

NEW Power BI and Copilot Integration

Power BI with Copilot Integration for Fast Data Search and Clear Insights

Connect Microsoft Copilot with Power BI to bring natural language interaction directly into WordPress sites. Users can ask questions using natural language, and Copilot uses Gemini to interpret the prompt, review the underlying Power BI reports, dashboards, datasets, or tiles, and deliver clear insights, summaries, or visual outputs based on the data.

Know More   

Related Articles

• WordPress Power BI Integration
• WordPress Power BI Single Sign-On (SSO)
• How to configure Row Level Security (RLS)?
• How to Get Sample Data in Power BI Desktop?
• How to view Power BI reports in mobile view?
• WordPress Office 365 App Integrations
• Frequently Asked Questions (FAQs)

Why Our Customers choose miniOrange PowerBI Embed Reports Solutions?

24/7 Support

Get prompt support from our technical experts, accessible around the clock for direct assistance

 Sign Up

Customer Reviews

Unbiased Reviews that speak for themselves. Click below to check our more.

 Reviews

Documentation

Get access to our detailed knowledge base, which includes comprehensive guides and instructional videos.

 Know More