Forum Discussion
Solved
Direct query with dynamic row level security authentication
Hello, I am trying to figure out how the authentication mechanism work with direct query from the service to data gateway and to the SQL Server. I know how the AS Live connection authentication...
Hi nivasnalla,
You can try a software like SQL Server Profiler then you will see it clearly what happens in the Server side. Please refer to the snapshot below. I defined a role [Color] = "Blue".
Best Regards,
Dale
When you set up your gateway you will select what User/Pass is sent from the Gateway to the source in order to provide authentication and grab the required data.
Row Level Security is handled by Power BI itself, thus you will grab all of the necessary data from the source and Power BI itself will apply the filtering to ensure the user only sees whatever is set up in the Roles they have been assigned inside the Power BI model.
Anonymous: Above explanation for Row level security is true for Import Query and not for Direct Query.