Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@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,
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
Thanks for your reply. I did tried a sample implementing RLS and want to understand what is the difference between RLS and Dynamic RLS?
@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
hi @Pallavi,
Actually it is exactly opposite. You cannot define rls on SSAS specifically. Using SSAS as a source for power bi has an advantage that ione is not required to define any security on the model. It simply carries forward the security of analysis services in terms of roles & permission as is.
Regards
Hemant
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |