Forum Discussion

AdmanPowerBI's avatar
AdmanPowerBI
Frequent Visitor
6 years ago
Solved

Row Level Security and Power BI Datasets

I have setup a "master" dataset which is published to the online service, which I subsequently use as a datasource for a whole bunch of other reports (like this). I would like to setup row level security to ensure that only the sales reps who are assigned to the accounts can see their orders. All of that went well when testing in desktop and for the online service when I use the master dataset. However when I went to test the row level security on a report that uses the power bi dataset as a data source, I couldn't get it to work. I made sure that users had access and security was setup in the original dataset in the online service.

 

I'm starting to wonder if this is even possible?

 

Thanks!

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi AdmanPowerBI ,

     

    "There is no option for "security" on the report that references my "master" dataset"

    It is correct, because live connection cannot configure RLS. RLS still apply to a report built when connected live to a dataset.

    After my tests, it works properly in the same workspace and different workspaces. I noticed these users are already "viewers", so I think that you could check the RLS in the original dataset.

     

6 Replies

  • blopez11's avatar
    blopez11
    Super User
    6 years ago

    Can you provide a little more detail please?

    When you say you couldn't get it to work, what specifically do you mean?  Consumers couldn't see anything, they could see everything?

     

    Are the reports in the same workspace?

    How are you sharing the reports with the consumers?

     

    This would be helpful in order to try and help

     

    Thanks,

    • AdmanPowerBI's avatar
      AdmanPowerBI
      Frequent Visitor
      6 years ago

      Thanks blopez11  and great questions.

      1. They couldn't see anything

      2. The reports are in different workspaces

      3. I'm sharing it through access to the workspace. I have the users as "viewers"

       

      There is no option for "security" on the report that references my "master" dataset:

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support
        6 years ago

        Hi AdmanPowerBI ,

         

        "There is no option for "security" on the report that references my "master" dataset"

        It is correct, because live connection cannot configure RLS. RLS still apply to a report built when connected live to a dataset.

        After my tests, it works properly in the same workspace and different workspaces. I noticed these users are already "viewers", so I think that you could check the RLS in the original dataset.