You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

Question

Options

• AMicrosoft Azure SQL Database
• Ba Microsoft SQL Server database
• Ca Microsoft SQL Server Analysis Services (SSAS) database
• DMicrosoft Excel

• A
  13% (6)
• B
  6% (3)
• C
  79% (37)
• D
  2% (1)

Explanation

Power BI Report Server is an on-premises solution with a more restricted set of supported data sources compared to the Power BI cloud service. A key supported and recommended data source for on-premises Power BI Report Server reports is SQL Server Analysis Services (SSAS), which supports live connections without requiring data to be imported into the model. SSAS is a proven, enterprise-grade on-premises analytical engine that integrates tightly with Report Server. While SQL Server (B) is also supported, SSAS is the exam-targeted answer for Report Server live connection scenarios. Azure SQL Database (A) is a cloud service and may not be accessible from a fully on-premises Report Server environment without additional networking. Excel (D) is a valid data source but not the recommended enterprise choice for Report Server publishing.

No community discussion yet for this question.