Row Level Security doesnt work with dynamic measure/measure slicer

[Anonymous]

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

[Anonymous]

bumping this if any faced this challenge

[Anonymous]

Hi All,

Anyone have any thoughts on this? Greatly appreciate your kind help!

Regards

CS

[v-jayw-msft]

Hi @Anonymous ,

According to the error message, it seems the column '%pop_dinamic' was not found. Check if it was still exists. It might was renamed.

Best Regards,

Jay

[Anonymous]

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?