Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Direct Query and Row Level Security - Do Viewers need to have read access to SQL Server database?

Hello all, I have a question regarding the viewer authentication in PowerBI report using DirectQuery and having Row Level Security applied when it's published in a PowerBI Workspace/PowerBI Service....
Accessing Dashboards
Direct Query
Row Level Security
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    It depends on how you have configured the credentials for the connection in your tabular model. If the connection is using the fixed account or impersonate service account options the that account will be used to execute the SQL queries. Your RLS restrictions will work fine with either of these options as the RLS filters are effectively translated into extra conditions on the WHERE clause for the SQL queries that are generated

d_gosbell's avatar
d_gosbell
Super User
4 years ago

It depends on how you have configured the credentials for the connection in your tabular model. If the connection is using the fixed account or impersonate service account options the that account will be used to execute the SQL queries. Your RLS restrictions will work fine with either of these options as the RLS filters are effectively translated into extra conditions on the WHERE clause for the SQL queries that are generated