Forum Discussion
Row Level Security doesnt work with dynamic measure/measure slicer
Hi all,
Previously all is working fine but suddenly it doesnt. No changes made.
I have a report that has few tabs. Few KPIs that can be filtered by branch. RLS is defined using branch.
One tab that shows the kpi by branch, works well when i try to view using the roles defined in RLS.
However, another tab that uses measurement slicer(turns measures into dimension) doesnt work when i try view using the roles define in RLS. .
With any role in RLS, it shows error and i noticed the measures I defined by slicers are gone. Without role in RLS, it work fine without error.
Any idea what could have happened? Previously it was working fine.
Regards
CS
4 Replies
Hi Jay,
Thanks for reverting. As I mentioned earlier, if i dont apply RLS(test as roles), i can see the dynamic metrics(metric slicer). But once i test using RLS role, it will throw out the error(with the error message, it really does show the metrics are gone when i try look over the list of fields). So my question is how can this happen and how to go about it. Previously there is no issue when I apply RLS. Is there changes in the underlying design of PBI on RLS or bug or anything that you can think of?