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.
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/
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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |