Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am using Power BI Embedded and am trying to embed a paginated report into my web application use a service principal. I have been able to successfully embed the report, but have a question about the authentication method that the report data source uses to connect to the Azure SQL Database. The only options I have been able to get to work are:
Neither one of these methods suit my use case very well. Ideally the report would use the service principal that the web site is using to connect to Power BI to connect to the database, but I have not been able to get this to work. If I change the report data source to use OAuth2 with 'End users use their own OAuth2 credential' checked then when I load the report in my web page I get an error saying 'This report contains invalid or unsupported data sources.'.
Is there a way to get the report to use the Service Principal to connect to the database? Or are there any other data source authentication options that I am missing?
Thank You
Solved! Go to Solution.
I ended up opening a support ticket with Microsoft, and wanted to post back here what I ended up finding out.
When embedding a paginated report using the 'app owns data' model your only options for authentication are a SQL Server username and password or a AAD username and password. It is not possible to use the service principal to authenticate with the database.
I ended up opening a support ticket with Microsoft, and wanted to post back here what I ended up finding out.
When embedding a paginated report using the 'app owns data' model your only options for authentication are a SQL Server username and password or a AAD username and password. It is not possible to use the service principal to authenticate with the database.
It's been a long while, do you or anyone else know if Microsoft was unblocked service prinical authenication?
Hi @Anonymous
Sorry, I can't repro your scenario on my side, please kindly raise it to the support team for better advice, thanks a lot!
https://powerbi.microsoft.com/en-us/support/
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.