Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We are working on setting up Power BI Embedded reports in a .net core web application. Following the examples provided by the online documentation, we were successful in setting up the Paginated Power BI (.rdl files) reports using a Service Principal.
However, when attempting to load Power BI Analytic (.pbix) reports we receive a 401 error on a call to https://wabi-us-east2-redirect.analysis.windows.net/explore/reports/..../modelsAndExploration?prefer... url. Further investigation using Fiddler we were able to find the response from the site which included the message PowerBINotLicensedException.
We have Power BI Pro/Premium users and have setup the Workspace as Premium as well.
Any help on why a Paginated report works and an Analytic one does not? Also, does anyone have thoughts on how to get passed the licensed exception when using a Service Principal?
Thanks -Brent Morgan
Solved! Go to Solution.
Thanks I had reviewed those articles prior to posing this question.
I was eventually able to get both Paginated and Analytics reports to work, although I split the mechanism for authentication. Paginated will use Service Principal and Analytics will use the MasterUser option. Not ideal, but it at least works.
Hi @BrentMorgan ,
You could refer to these:
https://powerbi.microsoft.com/en-us/blog/use-power-bi-api-with-service-principal-preview/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks I had reviewed those articles prior to posing this question.
I was eventually able to get both Paginated and Analytics reports to work, although I split the mechanism for authentication. Paginated will use Service Principal and Analytics will use the MasterUser option. Not ideal, but it at least works.