Help for Row Level Security

[DiePic]

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?
....

[DiePic]

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

[Anonymous · Accepted solution]

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.