Search Results :

×

Integrate Power BI with WordPress | WP PowerBI Reports, Dashboards Embedded

Integrate Power BI with WordPress | WP PowerBI Reports, Dashboards Embedded


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

Pre-requisites : Download And Installation

To configure Embed Microsoft Power BI reports on your site you would need to install the PowerBI Plugin:

Embed Microsoft Power BI reports, tiles, dashboards, Q&A, etc in WordPress site with support for Row-level security (RLS)

 Tested with 6.1.1

Steps to configure Azure AD for WP PowerBI Integration

1. Configure the Azure AD App registration

  • Log in to Azure AD Portal as admin
  • You will be represented with the home screen of Azure Active Directory.
  • Under the Azure Services section, select Azure Active Directory.

  • WP PowerBI Embed with row level security |  New registrations
  • In the left tab, under the Manage section, select App registrations.

  • WP PowerBI Embed with row level security |  New registrations
  • Click on New registration.

  • WP PowerBI Embed with row level security |  New registrations
  • Assign the Display Name in the name field and choose the account type.
  • In the Redirect URI field, provide the URL of your WordPress site and click on the Register button.
  • WP PowerBI 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.
  • WP PowerBI 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.
  • WP PowerBI Embed with row level security |  Client secret
  • Copy the value of Secret Key. This will be your Client Secret Key.
  • WP PowerBI Embed with row level security |  Secret key
miniorange img Add API Permissions to your Azure AD Application:
  • Go to API Permissions from the left navigation pane and click on Add a permission option.
  • WP PowerBI Embed with row level security |  Add a permission
  • Select Microsoft Graph under the Microsoft APIs tab.
  • Select Application Permissions and search for the User.
  • WP PowerBI Embed with row level security |  Select permission
  • Under User select User.Read and User.Read.All permission and click on the Add Permissions button.(Microsoft Graph)
  • Under Report select Report.Read.All permission and click on the Add Permissions button.(Power BI Service)
  • Click on Grant admin consent for Default Directory and click on Yes on grant admin consent confirmation.
  • You have successfully configured the Azure AD app to achieve User Sync into your WordPress Site.
2. Configure the 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 icon as shown below.
  • WP PowerBI Embed with row level security | click on icon
  • Under the Settings tab, click on the Admin portal option.
  • WP PowerBI 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.
  • WP PowerBI 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 Allow PowerBI Admin APIs then click on Apply.
  • WP PowerBI Embed with row level security | Allow PowerBi admin APis
  • Navigate back to the Home page. Select the Workspaces tab from the left pane and then select your workspace from the list.
  • WP PowerBI Embed with row level security | Select Workspaces
  • Navigate to the Access tab.
  • WP PowerBI Embed with row level security | Navigate to access tab
  • In the Access section, search for the application that you have previously configured.
  • From the below dropdown, select the Admin and click on Add button to assign this Azure AD application to your Power BI workspace.
  • WP PowerBI Embed with row level security | Select dropdown option
  • Select the report that you want to embedd in WordPress 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.
  • WP PowerBI Embed with row level security | Copy the IDs
3. Embedd your Power BI report into the WordPress
  • Navigate back to the WordPress Admin dashboard.
  • Go to the Pages tab form the left side bar and click on Add New button or you can edit your existing page.
  • WP PowerBI Embed with row level security | Click on Add New
  • Click on + symbol, search for the Shortcode.
  • WP PowerBI Embed with row level security | Add shortcode
  • Paste the Workspace_ID and Report_ID in the shortcode as shown in the below image. Click on Publish/Update button in the top rght corner.
  • WP PowerBI Embed with row level security | Add Workspace_ID
  • Visit the page to view the Power BI report.
  • WP PowerBI Embed with row level security | visit powerbi report

With this, you have successfully connected Power BI with WordPress allowing you to embed interactive PowerBI reports, charts, and dashboards in WordPress. With additional support for row level security, you can enable a granular view of your Power BI visualizations in your WordPress site.

Additional Resources

Why Our Customers choose miniOrange PowerBI Embed Reports Solutions?


24/7 Support

miniOrange provides 24/7 support for all the Secure Identity Solutions. We ensure high quality support to meet your satisfaction.

Sign Up

Customer Reviews

See for yourself what our customers say about us.
 


Reviews

Extensive Setup Guides

Easy and precise step-by-step instructions and videos to help you configure within minutes.


Watch Demo


We offer Secure Identity Solutions for Single Sign-On, Two Factor Authentication, Adaptive MFA, Provisioning, and much more. Please contact us at

 +1 978 658 9387 (US) | +91 97178 45846 (India)   samlsupport@xecurify.com

Hello there!

Need Help? We are right here!

support
Contact miniOrange Support
success

Thanks for your inquiry.

If you dont hear from us within 24 hours, please feel free to send a follow up email to info@xecurify.com