topic Re: Page (sheet) Level - Row Level Security in Developer

Page (sheet) Level - Row Level Security

rockykb — Thu, 02 Apr 2020 13:33:34 GMT

Hi All,

Is anyone have any idea how to apply Page (sheet) Level - Row Level Security in Power BI as we have limitation of applying the RLS in dataset only?

Although we can duplicate the dataset but is there any alternative way?

Thanks & Regards,

Rocky

Stay Safe

Stay Healthy

Re: Page (sheet) Level - Row Level Security

Greg_Deckler — Thu, 02 Apr 2020 14:40:34 GMT

No, you can't really do that. What I have done in the past when this comes up is that it is generally in the situation where people need to see the aggegate information that hides all of the underlying specific user/company information. In that case, I simply create a new data table with no RLS attached using something like SUMMARIZE or GROUPBY that aggregates the information appropriately.

Re: Page (sheet) Level - Row Level Security

rockykb — Thu, 02 Apr 2020 15:45:38 GMT

Are you referring from the same dataset?

Re: Page (sheet) Level - Row Level Security

mustafaasiroglu — Wed, 20 May 2020 08:52:22 GMT

Hello,

You can create tab(page) level security by conditional navigation feature coming with May 2020 release of Power BI.

I wroted details about this workaround here: https://www.linkedin.com/pulse/page-tab-level-security-conditional-navigation-power-bi-a%25C5%259F%25C4%25B1ro%25C4%259Flu/?trackingId=cFxRUKiaQCGafEOf9lva0Q%3D%3D