How to connect Azure SQL Database with MSI or cert in PowerBI report?

[jessli]

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?

[AlaaAlmaghrbi]

Hi, @jessli , Did you manage to fix this issue? I am trying to do same thing

[jessli]

@amitchandak 

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.

[linch]

Hi, Jessli, have you got through this issue? I'm trying to do the same thing.

[amitchandak]

@jessli , check if this is something what you are looking for ?

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal

[jessli]

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. 

[dsouza17]

@jessli Were you able to resolve this?  I am trying to do the same.

[amitchandak]

@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/