Applying Row Level Security on Bookmarked Report with Values selected in Slicer depends on the Role

[Amir851]

Hi,

I have multiple reports with each reports having two slicers named as the category & Items and all the tables in the data model has the column named as Category.  Each report has been bookmarked and linked to a button so that the user can Navigate between the reports.

Currently, I am applying RLS on each report by creating a role for each category. The issue is that I have set up some default value in each slicer in report & created a bookmark for that and linked that to the Buttons.

After applying the RLS to all reports, my both slicers present in each report has the same default value selected as before. My requirement is that Category slicer should have the value selected dependent on the Category Role.

For example, If I have a role Named as category 1, then the Category slicer should have the value selected as Category 1 in all Bookmarked page, If I have a role as category 1, then the category slicer should have the value selected as category 2 in all bookmarked pages. I am not sure how to proceed on this.

[v-cherch-msft · Accepted solution]

Hi @Amir851 

As far as I know, there is no elegant way.You may vote this similar idea which has been submitted and add your comments there to improve Power BI and make this feature coming sooner.

Regards,