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 secu...
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.

     

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.

       

      • AdmanPowerBI's avatar
        AdmanPowerBI
        Frequent Visitor
        6 years ago

        Thanks v-eachen-msft I will test again but make a copy of the dataset I was using. I am sure that I had users setup as viewers but I wouldn't be surprised. I will respond back today!