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 th...
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.
