Forum Discussion

moneelta's avatar
moneelta
Regular Visitor
7 years ago

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 exce...
GilbertQ's avatar
GilbertQ
Super User
7 years ago
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.
moneelta's avatar
moneelta
Regular Visitor
7 years ago

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.

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    If you remove them from the App Workspace and leave them as a member then the RLS will apply
    • moneelta's avatar
      moneelta
      Regular Visitor
      7 years ago

      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.

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        What if you add them to just the App