Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

truptis

Page Level Security in Power BI

In this post, we will seee how to implement Page Level Security in Power BI. Page Level Security indicates restricting access of few pages in the report with the users. Here's a work around to implement this:

 

Currently, we are considering 2 users. User 1 should be able to view only the External page where as User 2 can access both the pages (Internal as well as External). Firstly, create a disconnected table and put True/False values (Note: Conditions can vary based on the level of access to be provided) : 

truptis_0-1718968906812.png

 

Create a slicer and put Page name column in it. Add a forward arrow button too for page navigations:

truptis_1-1718969078550.png

Select the button, go to Actions -> Type: Page Navigation -> fx -> OK

truptis_2-1718969430194.png

With this logic, the page which is selected in the slicer it will redirect to that page after clicking the arrow button.

Note: It is necessary to select the page name (radio button) and then click on the arrow button for page navigation

 

Lastly, we need to implement RLS. Go to Modelling -> Manage Roles -> New Role -> OK

truptis_3-1718970010215.png

 

We can test the roles: Modelling -> View Role as -> Select the Role 

With this, we can restrict the access based on the users.

 

Comments