topic Can't connect to Data Source (the source is a dataset on Power BI Service) in Report Server

Can't connect to Data Source (the source is a dataset on Power BI Service)

Katebrk — Wed, 02 Jun 2021 12:32:13 GMT

Hello!

I have the following situation:

I have an uploaded dataset on Power BI Service, which I use for my report. I create the report in Power BI Desktop, using the connection to this dataset, everything works fine. Then I uploade that report to Power BI Report Server.

But when I open the report on Report Server, I see the error:

This is my string connection on Data Source tab, the string was created automatically by Power BI Report Server. I've tried to test connection with the same credentials I use for Power BI Service, but the connection failed also:

Could you please tell what could be the problem? The credetials are correct.

Is it possible that the string generated by Report Server is wrong? Does Report Server support datasets from Power BI Service? (PS. I have Power BI Service PRO license).

Re: Can't connect to Data Source (the source is a dataset on Power BI Service)

d_gosbell — Thu, 03 Jun 2021 01:32:27 GMT

Katebrk wrote:

Does Report Server support datasets from Power BI Service? (PS. I have Power BI Service PRO license).

Report Server does not support datasets from the Power BI Service. If you check the list of supported datasources here you will see that "Power BI Service" has no's in all 3 columns. If your dataset is in the service you need to host your reports in the service also.

Re: Can't connect to Data Source (the source is a dataset on Power BI Service)

Katebrk — Thu, 03 Jun 2021 06:22:26 GMT

Thank you, I see!