Forum Discussion

erwiegman's avatar
erwiegman
Regular Visitor
6 years ago

Problems with Auth2, Azure AD and SQL Row level security not working

Hi Community I have a problem with Azure AD authentication in PowerBI to pass through to an Azure SQL Database with row level security configured. When i connect to the SQL database everything wor...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi erwiegman ,

 

It may be that the instance of the login account does not match the account with RLS.

Refer to this:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-kerberos 

The map user names feature is a great way to work around when your user name in Azure Active Directory (Azure AD) doesn't match a UPN in your local Active Directory instance.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas#map-user-names-for-analysis-services-data-sources 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • erwiegman's avatar
    erwiegman
    Regular Visitor
    6 years ago

    V-lianl-msft 

    Hi,

    We are not using a gateway to a on-premise datasource. We are connecting to a Azure SQL database, and in the PowerBI desktop everything works as expected. I also think that in the PowerBI service something else is going on with the authentication, but i cannot seem to find a way to see which username is passed to the Azure SQL database. Those links are not helping with this.

     

    Also the RLS in PowerBI isnt helping, because this report should be a personal report with GDPR data in it (phonecall data). So we want 1 report and every use must have his own data. That is why we created a 'personal' RLS (which works in SQL with SSMS).