Power BI and SharePoint – the road ahead

Leipzig, 07/25/2018 – Microsoft has invested in modernizing and creating deeper integrations with SharePoint. In 2017, Microsoft has introduced the Power BI webpart for SharePoint Online and an updated Reporting Services Report Viewer webpart for SharePoint on-premises. Yesterday the release of the public preview of SharePoint 2019 was announced.
This decision was based on the consistent feedback from Microsoft users, and by making these changes, Microsoft will be able to innovate and release integration capabilities faster and more often that best meet the needs of customers now and in the future.

The Path Forward

Now, customers can use Power BI and optionally integrate their Power BI content into SharePoint 2019 and SharePoint Online, using either Power BI or Power BI Report Server. These are the most important new features:

  • Adding support for all major report types across both platforms. In the coming weeks, we’ll have the first public preview of Paginated (RDL) reports in Power BI Premium, giving customers full support for Paginated Reports, Power BI Reports and Excel Workbooks in Power BI.

  • Providing easier ways to report on your data in SharePoint. We’ve recently announced new functionality to make easier than ever to start visualizing your Excel tables and CSV files stored in SharePoint Online in Power BI. Additionally, for Power BI Report Server, we’re adding some new features that already exist in Power BI, but were previously available only through SharePoint integration for on-premises deployments. These include:

    • Power Pivot Scheduled Data Refresh. We first added support for Excel Workbooks in Power BI Report Server in October 2017, including the hosting and viewing of Excel Workbooks containing data models. We’ll be expanding this support to include scheduled data refresh of these workbooks.

    • Modern Authentication support. Security considerations are a key part of any BI deployment strategy, and many customers used SharePoint to handle claims-based authentication scenarios for their users. We’re adding native support for ADFS/AAD authentication to Power BI Report Server in an upcoming release.


Microsoft announced that there would be additional documentation and blog posts following the next weeks.

Microsoft Volume Licensing Gold Partner

Stay Up-to-date

For regular updates and articles from COMPAREX, click below to follow us:

 Follow us on LinkedIn

Interested in more than Microsoft?

Find here all press releases and blog articles of the COMPAREX Group:

 COMPAREX Newsroom