RLS Export

[Syndicate_Admin]

Good!
In my report I applied what RLS is, the problem is that when exporting from Power BI Service it does not respect my security filters.

For example:
Seller 1 should see info only from Region 1, and when you download it from the Power BI app there is no problem, you only see Region 1. The issue is that when exporting data from the service this filter does not respect me and seller 1 only shows the information of region 1 but when exporting the data in xlsx it downloads all the information.

Just in case, I have the latest version of pbi and excel.

Does anyone know how you could solve this problem?

[Anonymous · Accepted solution]

Hi @Syndicate_Admin 

If you are the designer of the RLS, and you view as a user to test the RLS and export the data , it will export all the data, because you a re the admin of the RLS, the RLS is work when the user role is the viewer, you can refer to the followin link about the RLS. Please check if the user role is viewer, it the user role is not viewer, the RLS will not work.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#using-rls-with-workspaces-in...

And you can refer to the following similar questions.

Solved: Extract data with RLS applied - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Thank you!!