Forum Discussion
pbix file as data source for ssrs reports
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 !
3 Replies
- Icey
Community Support
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.
- i want to use it in my application not in power bi on webas rdl file in report servermy app runs with olap as data source and i want to replace it with power bi data sourcewith dax query
do i need power bi premium to load ssrs file
does we can load in pro edition ??
