Embedding Power BI Report in SharePoint Online

In today's data-driven world, businesses rely heavily on visual analytics to make informed decisions. Microsoft Power BI, a powerful business intelligence tool, enables organizations to create interactive reports and dashboards to gain insights from their data. SharePoint Online, on the other hand, serves as a collaborative platform for organizations to share and manage content and applications.

Combining the capabilities of Power BI with SharePoint Online allows organizations to seamlessly integrate data visualization into their intranet portals or team sites, providing stakeholders with access to real-time insights within familiar SharePoint environments. In this step-by-step guide, we will walk you through the process of embedding a Power BI report into SharePoint Online.

Step 1. Prepare your Power BI report

Before embedding your Power BI report into SharePoint Online, ensure that your report is published to the Power BI service. Follow these steps to publish your report:

  1. Open your Power BI Desktop application.
  2. Load your data and design your report.
  3. Click on the "Publish" button in the Power BI Desktop toolbar.
  4. Sign in to your Power BI account and select the workspace where you want to publish the report.
  5. Once published, your report will be available in the Power BI service.

Step 2. Enable Embedding for your Power BI report

To embed your Power BI report into SharePoint Online, you need to enable embedding for the report. Follow these steps.

  1. Navigate to the Power BI service (https://app.powerbi.com).
  2. Open the report you want to embed.
  3. Click on the "File" menu and select "Embed Report."
  4. In the dialog box that appears, click on "SharePoint Online."
    SharePoint Online
  5. Copy the generated embed code.
    Code

Step 3. Embedding the Power BI report in SharePoint online

Now that you have the embed code for your Power BI report, follow these steps to embed it into SharePoint Online.

  1. Navigate to your SharePoint Online site where you want to embed the Power BI report.
  2. Go to the page where you want to embed the report and click on "Edit" to enter edit mode.
  3. Add a new web part to the page by clicking on the "+" icon.
  4. Search for and select the "Power Bi" web part.
    OTT Dashboard
  5. Paste the embed code copied from the Power BI service into the Power BI web part property pane Power BI report link configuration.
  6. Click on "Publish" or "Save" to save the changes to the page.
     Power BI

Step 4. Adjust Embed settings (optional)

Depending on your requirements, you may need to adjust the settings of the Power BI web part. Some common settings you might want to configure include.

  1. Display: Adjust the dimensions of the embedded report to fit the page layout.
  2. Navigation Pane: Choose whether to display the navigation pages option or not.
  3. Show Action Bar: Choose whether to display the action bar settings or not.
  4. Show Filter Pane: Choose whether to display the filter option or not.
     Embed settings

Conclusion

Embedding Power BI reports into SharePoint Online provides organizations with a seamless way to share insights and data visualizations with stakeholders within their existing collaboration platform. By following the step-by-step guide outlined above, you can integrate Power BI reports into SharePoint Online pages and empower your team with actionable insights derived from your data. Unlock the full potential of your data by leveraging the integration capabilities of Power BI and SharePoint Online.