page navigation with RLS Roles

[shaher12]

I have table called Departments , have Department column as Finance , Commercial ,...

I have created Roles based on each department

Also i have page navigation panel attached above

I need to make this navigation  affected by the RLS Role

Ex: if Roles equal finance the page navigation must show finance only

[lbendlin]

Page Level Security does not exist. Don't waste your time. 

Navigation pages provide very limited value.  You should focus on reducing the number of clicks between user and insight, not on increasing them.

[Zanqueta]

Hi @shaher12 

Dynamic Navigation Using Conditional Formatting

1. Create a Navigation Table
   • Create a table with columns:
     • PageName (e.g., Finance, Commercial)
     • PageDisplayName (friendly name)
     • PageURL or PageIndex (optional if using bookmarks)
   • This table should include all pages you want to navigate to.
2. Apply RLS to This Table
   • Apply the same RLS rules to this navigation table as you did for Departments.
   • For example, if the user belongs to Finance, only the Finance row will remain visible.
3. Create a Navigation Visual
   • Use a Table or Button with conditional formatting:
     • For buttons: Use Action → Page navigation → Based on field.
     • For tables: Use Action → Conditional formatting → Web URL or Page navigation.
4. Bind Navigation to RLS
   • When RLS filters the navigation table, only the allowed page(s) will appear.
   • If you use buttons, you can create a measure like:

SelectedPage =
SELECTEDVALUE(Navigation[PageName])

Then set the button’s Page navigation property to this measure.

Important: You cannot hide actual report pages dynamically in Power BI Service; you can only control what navigation options appear. If the user knows the page URL, they could still access it unless you apply RLS to visuals on that page.

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.