Row Level Security and Power BI Datasets

[AdmanPowerBI]

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!

[blopez11]

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]

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 · Accepted solution]

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]

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!

[blopez11]

I believe that report consumers also need at least read or viewer privileges on the source dataset

Please see: https://docs.microsoft.com/en-us/power-bi/service-datasets-across-workspaces#considerations-and-limi...

[AdmanPowerBI]

Thanks @blopez11 and @v-eachen-msft 

I must of not had the access in the original dataset configured properly for my users, even though I thought I did.

Appreciate the help!