Forum Discussion
Can SSRS Report use Power BI dataset as a Shared Datasource?
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!!
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!!