Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm using Dynamic RLS on one of our financial reports, and i'm facing some issues when sharing the report with end users. Some users are able to see all data instead of the applied RLS. I suspect that RLS takes some time to get distrubted between users. However, I can not find anything that confirms this theory. All of them have read access to the report. there is no difference between the users. I'm adding Azure Distrubtion group to the RLS on Power BI services (e.g. ALL@Company.com).
the RLS Formula i'm using is :
PATHCONTAINS(
'Staff Data'[Path],
MaxX(
Filter( 'Staff Data',
[Email]=USERPRINCIPALNAME()
) ,
'Staff Data'[Employee_Number]
)
)
It worked before on one of our other reports, but i did face the same issue initially where users were able to see all data but with time around a day or two, it actually filtered the data for them.
any help is greatly appreaciated.
Solved! Go to Solution.
I managed to fix it by re-adjusting one of the relationships we had from many-to-many to one-to-many, apparently there was some issue if a user was found in two different RLSs. Power BI just platently gives up, and handsover all the data 😅...
Anyways, hope this helps out someone eventually.
Best,
Hi, @Asalk
Thank you for the experience sharing of changing the relationships between tables to fix this problem, would you like to mark your own reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I managed to fix it by re-adjusting one of the relationships we had from many-to-many to one-to-many, apparently there was some issue if a user was found in two different RLSs. Power BI just platently gives up, and handsover all the data 😅...
Anyways, hope this helps out someone eventually.
Best,