topic Re: Can SSRS Report use Power BI dataset as a Shared Datasource? in Report Server

Can SSRS Report use Power BI dataset as a Shared Datasource?

Anonymous — Tue, 11 Aug 2020 00:03:03 GMT

I would like to know if I can publish an .rdl in Power BI Report Server that uses as it's data source a Power BI dataset in the cloud (premium capacity)? Thanks

Re: Can SSRS Report use Power BI dataset as a Shared Datasource?

d_gosbell — Tue, 11 Aug 2020 00:14:46 GMT

No this is not possible. Currently if you want to report on a dataset on premium capacity you need to also publish your rdl report on the power bi service.

Re: Can SSRS Report use Power BI dataset as a Shared Datasource?

KBO — Tue, 11 Aug 2020 06:27:16 GMT

Hi Anonymous ,

may be this link can also help: https://community.powerbi.com/t5/Report-Server/Dataset-in-Power-BI-Report-Server/td-p/703186

with SSRS it is possible but I guess you like to use .pbix files as datasource, right?

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: Can SSRS Report use Power BI dataset as a Shared Datasource?

d_gosbell — Tue, 11 Aug 2020 06:59:42 GMT

KBO wrote:

Hi Anonymous ,

may be this link can also help: https://community.powerbi.com/t5/Report-Server/Dataset-in-Power-BI-Report-Server/td-p/703186

with SSRS it is possible but I guess you like to use .pbix files as datasource, right?

@KBO that link is for a different type of dataset, not for a Power BI Dataset stored on the Power BI Service which is what Anonymous is asking about.

Re: Can SSRS Report use Power BI dataset as a Shared Datasource?

Anonymous — Tue, 11 Aug 2020 10:08:57 GMT

d_gosbell Thanks for the definitive answer... I can live with that. I like the more flexible subscription options in SSRS/PBIRS, so I guess I'll just reengineer my reports to hit the data warehouse directly instead of a PBIX in the cloud.

Re: Can SSRS Report use Power BI dataset as a Shared Datasource?

Anonymous — Wed, 12 Aug 2020 18:34:16 GMT

Turns out you CAN connect to the XMLA endpoint in Power BI Premium as a shared datasource for SSRS/PBIRS on premise!!! You just have to create a service principal account first (which I already did for PowerShell dataset refreshes.

CONNECTION STRING:

Data Source=powerbi://api.powerbi.com/v1.0/myorg/<<<WORKSPACE NAME>>>;initial catalog=<<<DATASET NAME>>>;User ID=app:<<<SERVICE PRINCIPAL APP ID>>>@<<<TENANT ID>>>;Password=<<<CLIENT SECRET>>>;

With this, I think there is officially nothing Power BI cannot do!!