Forum Discussion

Pallavi's avatar
Pallavi
Helper II
8 years ago
Solved

Does RLS applied only on Analysis Services?

  • Anonymous's avatar
    Anonymous
    8 years ago

    Pallavi,

    No matter which data sources you get data from, you can configure RLS for the their data models in Power BI Desktop as long as you choose "import" mode to load data into Power BI. And you can also configure RLS on datasets that are using DirectQuery, such as SQL Server. However, please note that when you use "Connect to Live" mode to connect to SSAS, you are not able to configure RLS for the data model in Power BI, you can configure Row-level security on the on-premises model.

    Reference:
    Row-level security (RLS) with Power BI Desktop
    Tutorial: Dynamic row level security with Analysis services tabular model

    Regards,
    Lydia

Pallavi's avatar
Pallavi
Helper II
8 years ago

Thanks for your reply. I did tried a sample implementing RLS and want to understand what is the difference between RLS and Dynamic RLS?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Pallavi,

The dynamic RLS described in the second article is configured by creating role to restrict data on the on-premises SSAS model.

The RLS described in the first article is for all the data model imported into Power BI Desktop, and it is configured in Power BI Desktop.

Regards,
Lydia