Forum Discussion

Reindeer's avatar
Reindeer
Frequent Visitor
3 years ago

RLS and Filters in Reporting server

Hi Everyone,

 

I am new to RLS, recently in my report I defined a role where particular users can view their specific companies. Although it works perfectly, but when it comes to filters on the right side (i.e. Power BI RS's default filters), they can view all the companies, which they are not allowed. When those companies are selected, there is no value for them in the visuals that means it is working, but I don't know why they are able to view other companies as well. The similar issue is happening with my different tables that are connected to company table.

 

Let me give you an example.

 

Assume there are 10 companies: Apple, Google, Vivo, Xiaomi and so on.

 

Role 1: All Projects related to company APPLE (Here the user can view all projects that comes under APPLE)  

Role 2: All Projects related to company GOOGLE (Here the user can view all projects that comes under GOOGLE)

 

Users Inserted in Role 1: XYZ1 and XYZ2

Users Inserted in Role 2: XYZ3 and XYZ4

 

Now, in an idle report server XYZ3 and XYZ4 should only see company GOOGLE in their Filter on the right. However, they are able to filter APPLE, VIVO, XIAOMI, GOOGLE and others also. Why?

 

Please note, this happens only for fitlers, Visuals are working fine. The same issue is with other filters that comes from different tables and I don't want XYZ3 to view APPLE Projects, even in the filters.

 

Thanks in advance.

No RepliesBe the first to reply