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.

[rudy_cortembert]

Excel Power Query has the same limitation...

[rudy_cortembert]

Idea created in Oct-2015, almost 200 votes and not implemented yet?!? It's a MUST HAVE!

[mike_wolf]

Is there some work-around (i.e. using ODBC connections) that I don't know about that other community users have used? I would appreciate any feedback.

[mike_wolf]

Any updates on support for Azure AD with Power BI? I don't understand the issue, this is a connection string change, surely this is something that can be easily accommodated. How can Microsoft's Power Business Intelligence solution not work with Microsoft's Best in Class data and authentication management solution, this is a big issue to me as I can't allow connections to my data any other way.

[v-alejba]

Is this implemented yet? Two weeks ago we just found out that it is not possible to connect to an SQL Azure DB using AZURE AD credentials from Power BI/Excel.

[pbiideas1]

Is there any update on this as we want to use the feature within our application. Thanks

[esnyder1]

My use case is an updating dashboard accessing an Azure SQL database that has "open" data for all employees. Would like any authenticated user to access the DB for read so they can modify the dashboard, so just want to add the ['company' employees] group. At present this doesn't seem to be possible because I have to access the database via database credentials.

[paul_hansell]

This has stopped us dead in our tracks on a Power BI / Azure SQL rollout for the company. Please prioritise the resolution asap.

[mattlueck]

Please add this feature so I don't have to use sql auth.

[rob_henwood1]

This is very necessary because we can't always allow access to databases using SQL Authentication. It's generally against our security policy.