Filter don't follow with the row level security

[selected_]

I have a fact table connected to a DIM table, and I've set up a slicer filter on a report page to filter data by company. In the role manager, I've configured it to only show data for the company the user has access to. However, when I use "View as" for a specific company, the page doesn't automatically display data for that company; I still have to manually select the company from the slicer filter on the page.

I attempted to change the slicer setting to "Single select" to force users to choose manually, but even after publishing it on the Report Server, this didn't resolve the issue.

I'm struggling to identify the problem or find a solution. Can you help me troubleshoot this?

[Anonymous]

Hi @selected_ ,
You have not properly created RLS for the manager role to view data for that particular compnay,thats why data is not showing as per your requirement.
create a proper role and add select the specified columns to view data as per the role
eg: new role - select table and column from the dataset and apply and view

[Anonymous]

Hi @selected_ 
Try out below Steps

It sounds like you are using a Power BI report with row-level security (RLS) enabled, and you want to have slicer filters automatically apply when using the "View as" feature in Power BI, but it's not working as expected

[selected_]

Copy and paste from ChatGPT, you should be permanently banned from this forum.  Shame on you.