Analyzing and Visualizing Data with Microsoft Power BI — Question 6

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?

Answer options

• A. Microsoft Azure SQL Database
• B. a Microsoft SQL Server database
• C. a Microsoft SQL Server Analysis Services (SSAS) database
• D. Microsoft Excel

Correct answer: C

Explanation

The correct answer is C, as Power BI Report Server is designed to work seamlessly with SSAS databases, allowing for complex analytical capabilities. While options A, B, and D could technically be used, they do not leverage the full capabilities of Power BI Report Server in an on-premises environment.