Page level security in Power BI

[Anony_mous]

Hi All,

I am new to power BI I got one requirement from client regarding page level security.RLS(Row Level Security) is applied to the report 1 year back itself Now the client wants page level security so that specific page is visible for only 2 usernames.Those 2 usernames is already existing in the earlier report level security.I tried with this table of data for page level security(Grades is the new page added in the report and for these 2 usernames the access is given for the grades page and for other usernames the access should not be given) The measure I wrote is this :

PageNavigation=

 CALCULATE(SELECTEDVALUE(PageAccess[Page]),FILTER(PageAccess,PageAccess[Username]=USERPRINCIPALNAME()))

I have created a button in other page if the button is clicked I have set the conditional formatting (PageNavigation) to navigate to the grades page based on the measure wrote but t is not working.

Table:

Username                 Page

abc@orgmail.com      Grades

xyz@orgmail.com       Grades

In my view the people who are all having access for the workspace will be having the access for every page in the report.Give some clarity on the view I have wrote and please give solutions to clear this issue.All suggestions are welcome thank you in advance.

Regards,

Anony_mous

[GilbertQ · Accepted solution]

Hi @Anony_mous 

I would like to let you know that there is no such thing currently in Power BI as Page level security.

What you can do is to hide certain pages from users, but it is not 100% secure. 

I am not sure how your current solution is working but what you could do is to remove the users from being members in the app workspace and try again?