Forum Discussion
Help for Row Level Security
Hi all
please, there is a way to filter data as in my picture? Now I'm pass this filter trought URL, but It's possible deceive the URL method, so I'm searching a new way to have a sure result.
...
part (1) - insert the field of another tabel that contain [CodAgente] + [NameAgente]
part (2) - is the table to put in relation for filter the rows
part (3) - I'll insert the [NameAgente] to filter rows
If this is possible, how can I send this parameter to the report?
....
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.
2 Replies
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 advanceHi 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.
