Forum Discussion
How to connect Azure SQL Database with MSI or cert in PowerBI report?
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?
7 Replies
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/
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.
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.
Hi, Jessli, have you got through this issue? I'm trying to do the same thing.
Hi, jessli , Did you manage to fix this issue? I am trying to do same thing
