Power BI together with SharePoint Online

  • 5 minutes

Once you've published a report to the Power BI service, you can embed interactive Power BI reports in SharePoint Online pages. From the Power BI service report: Use the File menu, select Embed > SharePoint Online to get the URL.

Screenshot of more options menu, SharePoint Online, embed report.

Then, from SharePoint Online, select Pages > New > Site Page > Power BI > Add Report and paste the URL. Select Publish to publish the report.

Screenshot of the SharePoint Online Publish button.

SharePoint Online makes relevant reports easily accessible through its Search function, even without knowing the workspace to which the report is saved.

Screenshot of search on SharePoint.

SharePoint as a data source

Power BI has three standard connectors with SharePoint. You can connect to both SharePoint Online and on-premises SharePoint for Lists. SharePoint folder pulls all files included in the folder.

Screenshot of SharePoint Connector Options.

It's important to note when utilizing the SharePoint folder connector, the M language query uses SharePoint.Files(). This function can cause slow refresh speeds due to the site metadata that loads with it. Updating the formula to use SharePoint.Contents() instead can provide a large boost to query-refresh speeds.