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 Power BI plugin for WordPress 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.
Pre-requisites : Download And Installation
Before starting the Power BI setup for WordPress, 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
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.
FAQs
More FAQs ➔What are the advantages of using the miniOrange WP Power BI plugin?
There are many benefits of using the miniOrange WP Power BI plugin, like:
- Strong security with Azure AD authentication
- Seamless access through Single Sign‑On (SSO)
- Role‑based visibility with Row Level Security (RLS)
- Easy embedding of reports, dashboards, and tiles using shortcodes
- Smarter decisions with Copilot AI to search, analyze, and uncover insights directly in WordPress
What types of Power BI content can I embed in WordPress?
You can embed reports, dashboards, tiles, and datasets. The miniOrange plugin generates shortcodes that make it easy to place this content inside posts, pages, or custom layouts.
Does the Power BI integration for WordPress support responsive design?
Yes. Embedded Power BI content adapts to different screen sizes, ensuring a smooth experience across desktop, tablet, and mobile.
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 MoreRelated Articles
Thank you for your response. We will get back to you soon.
Something went wrong. Please submit your query again
Sign Up
