Row Level Security

Question

Hi All,I have 2 Reports.1- Overall Report (where all users have the access)2- Region wise report (Where RLS is implemented and only the corresponding users can see their region data)The link to the Region Wise report is given in the Overall report&nbsp; - Using Web URL through Bookmarks.The issue is :In the Main report (Overall), the expectation is to provide buttons with different Region Names and when the user clicks on their corresponding region Button, it would take them to the Region Wise report and they would see their region data as the RLS is implemented there.The challenge , i am facing is with the Main report navigation part. All the buttons are taking to the same report where RLS is implemented.How to Disable/Hide the button click for other region users or like if they click on&nbsp; other region , it should show some Messages.The managers need to view all the buttons also.Is there any way to achieve this. I tied with USERPRNCIPALNAME, but ws not able to&nbsp; conect it with Azure AD as our securty groups are created there.Could someone Please helpme with this

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;Please refer to this blog, it will help you:Page (Tab) Level Security &amp; Conditional Navigation in Power BI!&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak · Answer

Anonymous , for Azure part see if these can help
&nbsp;
RLS with Azure https://www.pbiusergroup.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=4a918a3a-1317-1842-cc63-97fc10d3d0f3&amp;forceDialog=0https://powerbi.microsoft.com/fr-fr/blog/azure-active-directory-and-power-bi/https://www.youtube.com/watch?v=yJULDehAzVchttps://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

anonymous · Answer

amitchandak&nbsp;. Thanks Amit for the document. But that doesnt meet my requirment. Let me explain what I am looking for is how to&nbsp;1. Connect to Azure AD and fetch all the user&nbsp; and group details2. Create some DAX expression using USERPRNCIPALNAME so that, if we know a user from this region has logged in and hence the&nbsp; &nbsp;other Buttons should be made hidden/not clickable. (As we are not applying RLS on the main report. Everyone can see that. Only the&nbsp; &nbsp;Region buttons in the Main report is in question. )&nbsp;I did some research in the net and couldnt get the required nformation. Could you please let me know whether this can be acheived.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous , a different view point perhaps - but if your region level report already has RLS enabled, you can't really select a specific region button when opening the report.&nbsp;You could consider enabling RLS at the main report level, but that doesn't sound like it fits the use case.&nbsp;Just have one button for the region report - it will apply RLS when it opens anyway, so the viewer will only see the regions they have access to.&nbsp;Alternatively, I know Patrick from Guy in a Cube did some videos on conditional drill through pages - this may not exactly fit your use case, but it could give you some ideas 🙂&nbsp;&nbsp;thanks !&nbsp;

anonymous · Answer

Anonymous&nbsp;Thanks Gavin.&nbsp; I agree with you. But here is the catch.Tha managers should be able to see Regionwise reports also. Thats why we need to display all those region buttons and whenver other region user comes, it should perform some other action. thats where I am confused.

Forum Discussion

Row Level Security

7 Replies

Related content

Dynamic Row level security

Role Level Security

Dynamic Row level security issue

Row level security

Row Level Security