Is this mockup question correct?
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?
1. Microsoft Azure SQL Database
2. a Microsoft SQL Server database
3. a Microsoft SQL Server Analysis Services (SSAS) database
4. Microsoft Excel
one place i saw correct answer is 3 but I think we can connect to all 4 here.
Power BI report can use any of those sources. Here is more detailed list of them:
Yes you can connect all 4 database in Power BI desktop but if you need to connect to on-premises database then all except MS Azure SQL can be connected, as SQL Azure is cloud database and not a on-premise database.
Kalpavruksh Technologies | Microsoft Gold Partner
Denmark | USA | India | Germany
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.