Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report
Hi,
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.
Hi.
Power BI report can use any of those sources. Here is more detailed list of them:
https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
Regards
Andris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |