Forum Discussion
Power BI app and RLS Security
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?
9 Replies
- Hi there
The RLS will apply when they use the Analyze in Excel.
The one question that I have is the user in the App Workspace?
If any user is part of the App Workspace they will get to see all the data. That is currently by design which should hopefully be fixed in the New App Workspace experience.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.
- If you remove them from the App Workspace and leave them as a member then the RLS will apply
Check your tenant setting, you might have "analyze in excel with live connection "switched on.
