Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a report with Row Level Security (RLS) and published it in a App. The user is a part of a role that limits what they see in the report but if the go to the dataset and "analyse in excel" the donwloaded file has all the data. Is there a way to restric the data that is downloaded via the dataset?
Check your tenant setting, you might have "analyze in excel with live connection "switched on.
Thank you - yes they are part of the App Workspace. I did a test and clicked the "Analyse in Excel" option via the App Workpace as this Test User and they could see all the data. I wasnt sure if I hadnt applied the RLS appropiately.
I removed them from the App Workspace and added them as member of the Workpace (members can only view content). The RLS applies but they can still Analyse in Excel and access the other data. I assume this is a design issue.
Thats how I had it initially. It works great at filtering the report content but unfortunately users can still access the data if they analyse in excel.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.