Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.