Last May, we announced the integration between Power BI and OneDrive and SharePoint (ODSP) that allows you to view Power BI reports directly in a OneDrive or SharePoint document library available in preview. Previously, this capability was limited only to reports with data in import mode. We’re excited to announce that you can now view Power BI reports in ODSP with data live connected to a semantic model in the service! This new feature will elevate your experience with the existing Power BI and One Drive and SharePoint integrations.
Benefits of viewing live connected reports in OneDrive and SharePoint
Adding this additional data connectivity mode to viewing reports in OneDrive and SharePoint allows you to get even more value from M365 integration!
You can now:
- View live connected Power BI reports in OneDrive and SharePoint without having to download the file.
- Enhance and elevates teamwork by streamlining the collaboration process on live data reports.
- Take advantage of the familiar OneDrive and SharePoint interface and features to manage your Power BI files, such as version history and report sharing.
How to use live connect with OneDrive and SharePoint
With the Power BI and OneDrive and SharePoint integration, you can open your Power BI reports directly in OneDrive for Business and SharePoint and view them in the browser. If the report is live connected to a semantic model, you will see the live data and visuals without leaving the OneDrive and SharePoint view, having to refresh or download the report, or visit PowerBI.com. You can also edit the report directly in Power BI Desktop (or utilized the “Open in app” shortcut in the OneDrive SharePoint document preview/document library context actions) and save it back to OneDrive or SharePoint, and the changes will be reflected.
Requirements to use live connect with OneDrive and SharePoint
To use live connect with OneDrive and SharePoint, you need the following:
- A Power BI Pro license (also included with an Office E5 license) or PPU
- Build permission to access the semantic model connected to the report
- Permission to access OneDrive/SharePoint location where PBI file can be stored
Visit the documentation for Power BI and OneDrive and SharePoint integrations for more details on enablement and admin settings.
Please let us know your feedback and suggestions in the comments below or head over to ideas.powerbi.com and vote for further improvements we could make. We would love to hear your feedback!