Forum Discussion
RLS: Conditional Navigation, hiding buttons (.pbix included)
Hi guys,
I am currently creating a report in which I use buttons to navigate through pages, using row-level security (RLS).
These buttons should only be visible when a user has the correct authorization/security rights to do so.
For a part I have been able to make it work: the buttons only navigate to a page when you have sufficient security rights.
However, I want them to disappear entirely if you don't have the rights.
I've created a very simplistic .pbix file to showcase this. This is with january 2021 update, however.
I've created the table 'Users' with 2 users in it, user 'test' and user 'admin'. If you navigate to Modeling>View as and enter here 'test' and select 'Page' with it, you'll notice the security works.
The buttons have the following DAX logic behind them:
Button 2 Destination =
MAXX (
FILTER (
ADDCOLUMNS (
'Page Level Security',
"Rank", RANKX ('Page Level Security',[Order],,ASC)
),
[Rank] = 2 //change this number with button number
),
[Page Name]
)For button 'Home' which is the first button, replace the 2's with 1's.
Do you have any suggestions what I am missing to make the buttons themselves disappear?
Kind regards,
Igor
Power BI doesn't have this feature, right now.
As an alternate, You can try this workaround and it might help you - https://www.linkedin.com/pulse/page-tab-level-security-conditional-navigation-power-bi-a%25C5%259F%25C4%25B1ro%25C4%259Flu/
https://ideas.powerbi.com/ideas/idea/?ideaid=2dd57d8f-9e1e-4eb0-8dd1-05a566e522cf
1 Reply
- SivaMani
Resident Rockstar
Power BI doesn't have this feature, right now.
As an alternate, You can try this workaround and it might help you - https://www.linkedin.com/pulse/page-tab-level-security-conditional-navigation-power-bi-a%25C5%259F%25C4%25B1ro%25C4%259Flu/
https://ideas.powerbi.com/ideas/idea/?ideaid=2dd57d8f-9e1e-4eb0-8dd1-05a566e522cf