Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
Does RLS restrict Export Underlying data? If Row level security is applied and user (with viewer access) logs in to Power BI service and export "Underlying data", does RLS gets applied?
Thanks
Hi @Anonymous ,
Take a look at this video. It explained why the Export to Excel doesn't work with Power BI Row-Level Security.
https://www.youtube.com/watch?v=gpFRS5q6FiI .
Best Regards,
Jay
Thanks a lot for sharing this. The video helped me to clear my doubts with RLS and exporting data.
Regards,
Bala
Hey @Anonymous ,
RLS will be applied!
Assuming a user has only access to the 2 German cities Hamburg and Munich, and exports data of a bar chart that depicts Germany, only the unerlying data of Hamburg and Munich will be exported (my 2nd assumption, the relationship between country and city are exists in the model)
Regards,
Tom
Thanks Tom, just to clarify, RLS works for "Underlying data" also? For Summarized data option, we know it's work.
Hey @Anonymous ,
RLS does not restrict Report feature like export data.
If you do not want underlying data to be exported, then you have to use the report settings:
You have to be aware that this is NOT a security feature.
Regards,
Tom
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.