Pbix File as DataSource RRS feed

  • Question

  • 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 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  

    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 ??

    ben frenkel

    Tuesday, December 3, 2019 8:42 AM