Learn about what data sources you can connect to within Power BI Report Server.

Power BI Reports

Currently, the only data source supported for Power BI reports are a live connection to Analysis Services (tabular or multidimensional). More data sources will be added in future releases.

August 2017 preview

The August 2017 preview includes support for non-Analysis Services live connections. This includes imported data. You can download the August 2017 preview over at powerbi.com.

There are a few limitations with using non-Analysis Services live connections.

  • Scheduled data refresh is currently not available for reports using imported data.
  • DirectQuery data connections are not currently supported.
  • Scale-out environments are not officially supported.
  • Reports must be smaller than 50 MB in size.

Cannot upload imported or DirectQuery sources

If you try to publish a Power BI Desktop file that contains anything other than an Analysis Services live connection, you will see the following error.

Can't upload this report

We can’t open this Power BI report because it contains an unsupported data source connection or embedded data. This version of Power BI Report Server supports Power BI reports that connect live to SQL Server Analysis Services or Azure Analysis Services.

Other reports

Other report types support the same data sources that are present in SQL Server Reporting Services. For more information, see Data sources supported by Reporting Services.

Next steps

User handbook
Quickstart: Paginated reports
Quickstart: Power BI reports

More questions? Try asking the Power BI Community