cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dannyb_sbm
New Member

Connect to Azure SQL Database Using Active Directory User

Is it possible to connect to an azure sql database using an azure active directory user?

I've got the contained database users set up in azure sql and can connect to the database using SSMS and the active directory username/password.

But when I try to connect to the azure sql database in Power BI, the username name@company.com doesn't work. Does it only allow connections by sql logins?

5 REPLIES 5
UOLandrewdale
Helper II
Helper II

looks like you can use the ODBC setting on the Get Data screen

see following for details

https://blogs.msdn.microsoft.com/azuresqldbsupport/2017/04/06/connect-from-power-bi-to-azure-sql-dat...

Anonymous
Not applicable

We're in the same position too.

Anybody have an update guys?

Looks like there is an idea out there that needs some more votes. I would assume this has to be in the pipeline, but it's not available yet as far as I can tell.  Perhaps some votes will help.

 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10172688-sql-azure-connector-with...

jldaley86
Advocate II
Advocate II

@dannyb_sbm We're in the exact same position! It seems like it bypasses Azure AD and just connects directly to the database using SQL Authentication. A little disappointing given PBI mentions it can support any underlying datasource that allows RLS, however there's no evidence to date that it can be achieved via Azure SQL V12.

Greg_Deckler
Super User
Super User

I've only had success with database credentials.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors