Neil Palmer on 12 Oct 2015 18:02:41
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.
Administrator on 10 Jan 2018 02:01:06
This feature has shipped in the January 2018 update for Power BI Desktop. Please refer to the official announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth
- Comments (62)
RE: SQL Azure connector with Azure AD Auth
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.
RE: SQL Azure connector with Azure AD Auth
Have asked Miguel (the product owner for this area) to take a look.
Thanks
RE: SQL Azure connector with Azure AD Auth
As stated in a previous comment, having to use SQL authentication means we need to roll our own row and table level security.
RE: SQL Azure connector with Azure AD Auth
yeah. Spent quite a lot of time setting up Azure AD including an Azure AD group so users could use Windows authentication to the database from SQL Management Studio only to find that when they use Power BI Desktop they have to use SQL Authentication
RE: SQL Azure connector with Azure AD Auth
Excel Power Query has the same limitation...
RE: SQL Azure connector with Azure AD Auth
Idea created in Oct-2015, almost 200 votes and not implemented yet?!?
It's a MUST HAVE!
RE: SQL Azure connector with Azure AD Auth
It is possible to connect to Azure SQL DB using AAD though ODBC 13.1 . But this requires a gateway for data refresh.
So yes, please update Power Bi Azure SQL DB and DWH connectivity to support AD Universal Authentication, like other tools (e.g. SSMS) do.
RE: SQL Azure connector with Azure AD Auth
Hard to connect and configure azure to use AD Auth
RE: SQL Azure connector with Azure AD Auth
We would like to utilize Power BI to connect to Azure SQL DB via AAD, in DirectQuery mode, with RLS implemented in the SQL DB for implementing row-level security. Objectives here are (a) manage RLS in the source so it's reusable & consistent across numerous datasets & reports rather than contained in one single Power BI file, (b) utilize DirectQuery because dataset is larger than the 1GB limit for importing/refreshing in Power BI, and (c) utilize Azure Active Directory for authentication so users don't have to keep track of a separate ID/PW.
RE: SQL Azure connector with Azure AD Auth
This implementation may be what slows us on the Azure SQL Data Warehouse. Looking forward to the Azure AD Auth!