Data Source supported by on-premises Power BI Report Server?

[Anonymous]

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

[Kalpavruksh]

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.

[andris]

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