Forum Discussion
Dynamic tab/page level security
Hello,
I am trying to find a way to dynamically hide/show tabs in a Power BI report. I am aware of RLS and would use this but in this case we are outlining a report at different levels: so for example, one tab would show enterprise level data while another, department level data. We want the user with the assigned access to only see their tab. So a CEO can see enterprise and dept tabs and a dept manager would only see the department level data tab. Using RLS could be part of the equation, but wouldn't fully do it because we wouldn't a dept manager to go into enterprise tab and make incorrect conclusions.
So, is there a way to dynamically hide/show tabs like this? Or any clever workarounds?
Hi Anonymous ,
I found an idea for the requirement. Maybe you could vote up to get it fixed quickly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Anonymous ,
It is possible with Power BI Embedded and Javascript SDK.
We have to identify the role 1st and hide the pages using JavaScript functions.Reference : https://microsoft.github.io/PowerBI-JavaScript/demo/pagenavigation.html
If you are trying to implement the same in Power BI service, at present there is no option available. As an alternative method, you can create multiple reports based on the role. Then provide access to the corresponding people. Finally, you can create another report with a single page. You can mention some introduction to your report. Then you can provide a button for navigating the original report. In the Button settings, Turn ON the action and choose type as Web URL. Here you can use conditional formatting and choose a measure that returns dynamic report URL based on the Role.
Button Settings
If you wish to implement the dynamic RLS, please refer to this post - https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399
Regards,
Nandu Krishna
Hi Anonymous ,
I found an idea for the requirement. Maybe you could vote up to get it fixed quickly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Anonymous
Refer to this blog
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂nandukrishnavs thanks for the link! this is super helpful
