How to Embed a Power BI Report in an Internal Company Portal
Question details
The user needs to securely embed an interactive Power BI report into SharePoint Online or a custom internal company portal for authorized users.
- Product
- Power BI / SharePoint Online
- Device & OS
- not provided
- Scenario
- Distributing and displaying internal business intelligence data to sales managers and staff through secure company web platforms.
- Observed behavior
- The user requires the correct methods for secure report embedding and clarification on the licensing requirements for portal viewers.
Verify that your report is fully published to the Power BI service and that you possess a Power BI Pro license with editing permissions for the target SharePoint site or internal portal.
Use the Power BI Web Part for SharePoint Online
The most seamless and secure method to embed reports within the Microsoft ecosystem is utilizing the native SharePoint web part.
This method ensures that data remains secure and respects all row-level security (RLS) configurations established in your Power BI dataset.
Navigate to your published report in the Power BI service. Click on the 'File' menu, select 'Embed report', and choose 'SharePoint Online'. Copy the generated URL.
Go to your SharePoint Online target page and click 'Edit'. Click the '+' icon to add a new web part and select 'Power BI' from the menu.
In the Power BI web part properties pane on the right side, paste the copied report URL into the 'Power BI report link' field. Select your desired page and display options, then click 'Republish' to save the page.
Use Secure Embed for Custom Internal Portals
If you are utilizing a third-party or custom-built internal company portal, you can generate a secure HTML iframe code.
Enhance Your Daily Data Analysis with WPS Office
While Power BI is a robust tool for interactive enterprise dashboards, everyday data management, pivot tables, and charting can be handled effortlessly with WPS Spreadsheet. As a free, lightweight, and highly compatible alternative to Microsoft Office, WPS Office ensures a seamless experience for your daily reporting and data visualization needs.
- 1. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Import Your Data: Open WPS Spreadsheet and easily open any existing Excel files or import raw CSV data.
- 3. Create Visualizations: Navigate to the 'Insert' tab to build PivotTables and visually appealing charts to share with your team.
Frequently Asked Questions
Can I embed a Power BI dashboard instead of a report?
No, Power BI dashboards cannot be embedded using the secure embed iframe or the SharePoint Online web part. These embedding methods only support individual Power BI reports. To share a dashboard, you must use Power BI Apps or share it directly within the Power BI service.
Do users need a Power BI Pro license to view an embedded report?
Yes, generally all viewers must have a Power BI Pro or Premium Per User (PPU) license to view an embedded secure report. The only exception is if the report is hosted in a workspace backed by a Power BI Premium capacity (an EM or P SKU), which allows free users to view the content.
Is it possible to embed Power BI reports publicly without requiring user login?
Yes, but it is not recommended for internal data. You can use the 'Publish to web' feature in Power BI, which generates a public link that does not require authentication. However, this method bypasses all security and makes the data accessible to anyone on the internet, so it must never be used for confidential company portal reports.
