Row level security is not applied when exporting data into .xls

[Anonymous]

Hi,

I've got RLS in all my reports and have realised that although tables, graphics and all data appear filtered as it should, when users try to export into .xls they get ALL the data, so privacy cannot be maintained. Is there any way to fix it?

Thanks in advance

[v-chuncz-msft]

@Anonymous 

That works fine for me. You may take a look at the post below.

https://community.powerbi.com/t5/Issues/RLS-security-does-not-apply-on-exported-data-when-tested-by-role/idi-p/609548

[Anonymous]

Hi,

sorry but I don't find solution in the post you are referring to, in fact, it is said that it is the expected behaviour, am I wrong in my interpration?

Thanks