Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
jessli
Microsoft Employee
Microsoft Employee

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 7
AlaaAlmaghrbi
New Member

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

 
jessli
Microsoft Employee
Microsoft Employee

@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
Microsoft Employee
Microsoft Employee

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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. 

Anonymous
Not applicable

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

amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.