Forum Discussion
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...
Hi there
have you configured SSO via the Gateway connection?
https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect#:~:text=Single%20sign%2Don,-After%20you%20publish&text=To%20enable%20SSO%2C%20go%20to,SQL%20database%20or%20data%20warehouse.
have you configured SSO via the Gateway connection?
https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect#:~:text=Single%20sign%2Don,-After%20you%20publish&text=To%20enable%20SSO%2C%20go%20to,SQL%20database%20or%20data%20warehouse.
No i didnt i'm connected to a Azure SQL database so no need for a Gateway. I did the exact step as in the link you supplied. Also i did a SQL profile trace with Azure data Studio, and i dont see any queries coming by. So i think it is related to the logon by the PowerBI service, but i dont see a way to confirm if this is the case.