Dynamic RLS and Hiding Tabs

[Anonymous]

Hi all,

I have read a lot of conflicting information about what RLS can and cannot do. Does Power Bi currently have the capability to configure RLS that will hide tabs in a report that a person (defined by a role) does not have security to see? I have successfully configured the RLS which allows them to click to the pages that are "theirs" but they can still see and have access to the other tabs in the report.  Our goal is to have Person A have access to and see tabs 1-3, Person B have access to and see tabs 4-6, etc. Is anyone able to tell me either what step I'm missing or if this is not possible?  At this point, we don't know if we should pivot and just break the "master" report with the 85 tabs into separate reports for each group or if we can configure this one massive report. Your help is greatly appreciated

[amitchandak]

@Anonymous , Have you already explored RLS with dynamic page navigation? Seems like atleast part of it.

If not see this example

https://youtu.be/FrEDZZXiit8

[Anonymous]

Yes, I have. the issue is not setting it up so they can navigate to their pages. My issue is hiding report tabs they shouldn't have access to. Even if I set it so they can navigate to certain pages they can still see and open other tabs.

[amitchandak · Accepted solution]

@Anonymous , The way I tried is that I have hidden all pages and given access to the pages only using the slicer. Not sure that can help in your case 

[Anonymous]

Hi- that might actually work. So, when your user opens the report they only see a page with the slicers and they jump to the one they want to see? If so- that may work.  How does one hide all the pages? Assuming you set up a home page that had the slicers and people could then navigate to specific pages. That could be a work around. Can you send a link to a guide or video? Thank you so much. I've been working on this for a bit now and need a little guidance.