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
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
    • moneelta's avatar
      moneelta
      Regular Visitor
      7 years ago

      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.

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        I am pretty certain that it will work right with Analyze in Excel.