Forum Discussion
Does Row-Level Security Always Decrease Performance?
Hi, mattkocak ;
For example, if there are 10,000 rows in a table, but a user only has access to 1,000, Then would Power BI run all of its queries against only those 1,000 rows? Or does it run the queries against the 10,000 rows with additional filters that decrease the performance.
I think it runs the queries against the 10,000 rows with additional filters,
For avoiding RLS:
Maybe it refers to two datasets. For example, A dataset of 10 million lines has two roles. Then, only the remaining data of A should be filtered out at the beginning of data import and publish to A workspace. Secondly, filter out B's data and publish it to B's workspace, so that the performance will be better. So only for a small number of characters.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, mattkocak ;
For example, if there are 10,000 rows in a table, but a user only has access to 1,000, Then would Power BI run all of its queries against only those 1,000 rows? Or does it run the queries against the 10,000 rows with additional filters that decrease the performance.
I think it runs the queries against the 10,000 rows with additional filters,
For avoiding RLS:
Maybe it refers to two datasets. For example, A dataset of 10 million lines has two roles. Then, only the remaining data of A should be filtered out at the beginning of data import and publish to A workspace. Secondly, filter out B's data and publish it to B's workspace, so that the performance will be better. So only for a small number of characters.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.