Forum Discussion

Anonymous20's avatar
Anonymous20
Regular Visitor
3 years ago
Solved

Row level security

    Is it possible to use RLS logic in a PowerBI direct query?    
Need Help
  • olgad's avatar
    olgad
    3 years ago

    You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop.


    https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

olgad's avatar
olgad
Resident Rockstar
3 years ago

You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop.


https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls