Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
To meet the complicent requirement , we moved our DB into the AME subscription and with JIT enabled. While it is also required to connect to SQL with MSI/cert connection instead of SQL connection, according to complience requirement.
Then that makes it not working for us to use the end user's AAD credential. So would you help on the information about how to connect Azure SQL Database with MSI/cert in PowerBI report?
not exactly, I want the power bi to connect the azure sql with some azure managed identity or cert, not an end user aad account.
Hi, Jessli, have you got through this issue? I'm trying to do the same thing.
@jessli , check if this is something what you are looking for ?
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal
Hi @amitchandak
I'm not sure whether I had the correct understand, but seems the wiki is saying how to embed powerbi into other application, while that's not our case.
Our case is , we need the powebi to connect to azure sql DB with MSI/cert auth, as the end user's pass-through AAD auth not working in our secenario due to complience requirements.
@jessli , Not very clear, you want AAD at both places ?
Refer
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth
https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
57 | |
54 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |