P0023 – Row-level security (RLS) with Power BI

BIDA Forums Forums Technical Topics 2-Databases 2-SQL Server P0023 – Row-level security (RLS) with Power BI

Viewing 0 reply threads
  • Author
    Posts
    • #690
      Peter Jones
      Keymaster

        Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn’t restrict this data access.

        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. The security option will not show up for live connection datasets.

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

        Best Regards
        Peter Jones

    Viewing 0 reply threads
    • You must be logged in to reply to this topic.