pbix file as data source for ssrs reports

[project101]

i have power bi pro 

and i need to use one data source for power bi and ssrs reports 

the power bi report builder can connect to power bi on colud as data source

but you c'ant use the rdl file in report server reports 

the connection string by exporting  power bi report to excel  ( data> connctions ) 

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-af48264b-2aad-4658-bae4-a25097d221ff;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 929d0ec0-7a41-4b1e-bc7c-b754a28bddcc;Update Isolation Level=2

this string can't be use as connection string in ssrs 

is there any solution in pro edition ??

xmla endpoint is not working as well for pro users as far i know !

[Icey]

Hi @project101 ,

I suggest you to use Power BI Report Builder to create a paginated report and upload it to the Power BI service.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[project101]

do i need power bi premium to load ssrs file 

does we can load in pro edition ??

[project101]

i want to use it in my application not in power bi on web 

as rdl file in report server

my app runs with olap as data source and i want to replace it with power bi data source 

with dax query