Forum Discussion
Can SSRS Report use Power BI dataset as a Shared Datasource?
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
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.
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!!
5 Replies
- d_gosbell
Super User
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.
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.
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!!
- KBO
Memorable Member
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!- d_gosbell
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.
