Row level security - export data

[LLT1021]

Hi,

I have a problem with RLS. It works fine in service as everyone is seeing the restricted information, but when exporting data to excel the RLS is not working anymore (not only in the 'view as' role but also in real). 

Does anyone know a solution to this problem?

Thanks in advance!

[LLT1021]

Thanks for your reply! Clear, but in this case indeed this group is defined as viewer. Are there reasons why RLS would not work when exporting?

[v-mengzhu-msft]

Hi @LLT1021 ,

Did you give them access to the dataset?

Best regards,

Community Support Team Selina zhu

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

[djurecicK2]

You need to have the "viewer" role in order for row-level security to be enforced for export. If you have higher access than viewer (member, contributor, admin), RLS will not apply.

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