SQL Azure connector with Azure AD Auth

[np123]

Update the SQL Azure connector to use Azure AD Auth. This will allow row level security in the database to be used with PowerBI. It would be great to have PowerBI pass through user credentials to the database so that data can be kept secure.

[fbcideas_migusr]

'I came across this issue recently while trying to do the same with PowerBI. This is what I'm using until the team gets AAD support, you can replace the parts in <> with your values: = AdoDotNet.Query("System.Data.SqlClient", "Server=;Initial Catalog=;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=""Active Directory Integrated"";", "")

[kostenickj]

I can't believe this doesn't already exist. We need this ASAP as it has stopped us dead in our tracks!

[mpiecyk]

Perhaps I should make a separate Power BI idea, but please support Azure SQL Data Warehouse with Azure AD Auth as well. It currently only supports Windows authentication which is not working for me (just like it doesn't work in SSMS either) and SQL authentication. It looks like for now we need to create an Azure Analysis Services endpoint connected to our DBs using DirectQuery to get AAD authentication working.

[fbcideas_migusr]

Can we please have some official comment on the status of this request?

[nori1]

An update on this would be appreciated.

[james_veitch]

What's the update on this? Have an admin stating "Have asked Miguel (the product owner for this area) to take a look." on January 24, 2017 9:57 PM but can't see anything further 4 months later? Surely this has got to be a huge priority for anyone wanting to seriously use Power BI in an Enterprise production environment.

[filious_louis]

What is the update on this? This is a very basic requirement. We use the same AAD for SQL, SQL DW, and Data Lake. You should be able to login seamlessly using your AAD credentials.

[JohnDawson]

This basically another vote; similar points to those already raised by other people; two notes 1) I don't like SQL Server authentication mainly as I have to embed the login credentials in R-script, which is insecure 2) AAD authentication not available in ODBC either

[v-vipomb]

You can read this article for a work around to use Azure AD in Power BI. https://blogs.msdn.microsoft.com/azuresqldbsupport/2017/04/06/connect-from-power-bi-to-azure-sql-database-using-aad-authentication/

[manish_57]

common MSFT do something this very critical for our cleints. ANy update??/??????