Forum Discussion
Help for Row Level Security
Hi DiePic ,
There're two kind of RLS in Power BI: static and dynamic.
Static row level security is simple to implement, however, if you have thousands of roles, then it would be a nightmare to maintain. For example, if you want to create a payroll Power BI report, in a company with ten thousand users, you want every user to have his/her role. Dynamic row level security is the answer for such scenarios.
Yeah, your ways here are all kind of static. You can try a dynamic way.
Below are some blogs talking about it, please kindly refer to
Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is a possible way, but if I've 100 Agents in my field, that can become a problem.
Remain that I'll be able to force the parameter opening the file both on premise and on cloud.
Any suggestion or help will'be apprecied.
thanx in advance
Hi DiePic ,
There're two kind of RLS in Power BI: static and dynamic.
Static row level security is simple to implement, however, if you have thousands of roles, then it would be a nightmare to maintain. For example, if you want to create a payroll Power BI report, in a company with ten thousand users, you want every user to have his/her role. Dynamic row level security is the answer for such scenarios.
Yeah, your ways here are all kind of static. You can try a dynamic way.
Below are some blogs talking about it, please kindly refer to
Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.