Announcing live connect for Power BI report integration with OneDrive and SharePoint (Preview) | Microsoft Power BI Blog


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.

A report being viewed in the OneDrive Viewer
Figure 1 – A report being viewed in the OneDrive viewer with live connect.

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.
Example of report version history in One Drive and SharePoint
Figure 2: With OneDrive and SharePoint and Power BI integrations, you can view the version history of your Power BI report.

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 bundled 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!



Source link

Be the first to comment

Leave a Reply

Your email address will not be published.


*