Data sources and connectivity options

All three connectivity options for Power BI Reports (import, DirectQuery, and Live connection) are supported by the Power BI Report Server. As one example, corporate BI teams could develop DirectQuery and Live connection reports based on a Teradata database and a SQL Server Analysis Services model, respectively. Business users with Power BI Pro licenses, however, could import data from Excel and other sources to the Power BI Desktop version optimized for the Power BI Report Server and publish those reports to the Power BI Report Server.

Power BI reports deployed to the Power BI Report Server cannot currently utilize a single Power BI dataset (PBIX file) as their data source, as described in the Live connections ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.