How to use Azure Active Directory Authentication with Power BI

[one_too_many]

Hello,

I'm using an Azure SQL DB with Azure AD. I can connect to this using SSMS and SSDT but when I try to connect with Power BI Desktop it won't authenticate the Azure Active Directory account. If I use an SQL login with Power BI it works fine.  Any thoughts on what I need to do to get this up and running?

Also... when I publish to the Power BI Web application if I go to the connection settings in the web app for the Azure SQL DB it shows its connected with a windows account by default although its published with the SQL account, of course when you try to set the windows account it fails so it is set with the SQL user but does not display this correctly when you go to check / change the setting.

Any pointers would be welcome.

Many thanks

M.

[v-sihou-msft]

@one_too_many

Currently, it's still not supported to connect SQL Azure with Azure Active Directory Authentication. Please vote this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10172688-sql-azure-connector-with...

Regards,

[one_too_many]

Aggghhhh.

😔😕

Thanks

M

[UOLandrewdale]

in case anyone else finds this old thread, you can connect if you use ODBC connection in POWER BI Get Data. See following for details

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