Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ex...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    I found an idea for the requirement. Maybe you could vote up to get it fixed quickly.

    Page (Tab) level Security. 

     

    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.

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

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