Disable RLS in reports using dataset with RLS

[Tormod_GK]

Hi!

Instead of having to maintain multiple datasets to different reports I am making one big dataset which I connect my reports to. In this dataset I have RLS which is needed for most reports, but I would like to have some reports without RLS but still use the same dataset.

Is there a possibility where I can use the same dataset or do I have to make a copy and then remove RLS in the copy? I hope to avoid the latter since I then have to either do things twice (when I alter the dataset) or having to make a copy each time.

Best regards,

Tormod

[kflehr]

I was unable to turn off RLS in Power BI so I achieved this through data where I altered just the RLS Table itself.  This allows you to still use the same underlying data and get RLS security on the individual tables and graphs in the same report.  In other words, you can have tables and graphs on the same tab where you can limit access or open it up to everything.

Take your current RLS Table and add a field like RLS Switch = 'ON'.  Then create and append another table which each person access to everything and add the field RLS Switch = 'OFF'.  Now, in Power BI you can add this field to your Filters and turn the RLS ON/OFF through by making this change to your RLS Table. 

[gavin007]

I have encounted the same thing and it is not a uncommon practice to have the same dataset for diferernt reporting purpose, hence one require RLS and the other doesnt.

Typical use case is one report for individual sales rep where they can only see their own sales detail, where the same dataset will build a report to show high level sales data for the same user. 

[Stachu]

by "without RLS" you basically mean access to all of the data? why not create a role that has access tor everything?

[Tormod_GK]

Hi!

Then the persons in this role would see everything in all other reports as well. I like to use RLS so that they see figures that are important to them, especially in the dashboards. But in some reports (benchmark/comparison) I would like the same persons to see everyting. So I was hoping that I could skip using RLS in some specific reports.

[v-yuta-msft · Accepted solution]

HI Tormod_GK,

Do you mean you want different pages have different role? The different pages belong to one report(dataset) and you can only assign one role to one dataset. To achieve your requirement, I'm afraid you should rename your pbix file and publish again so that you have two datasets which can be assigned with two different roles at the same time.

Regards,

Jimmy Tao

[xiaogou0401]

Do I need to remove RLS in the renamed file?

[Tormod_GK]

Hi!

Yes something like that. Having some reports that use the same dataset with RLS, but without using RLS. Like a feature when making the report, like saying "disable RLS in this report" 🙂

But I expected that I must do this the hard way, meaning making a copy, delete RLS and then publish. It will just take a bit more time to maintain and do changes in the dataset (since I want them to be exactly the same).

Best regards,

Tormod

[v-yuta-msft]

Hi Tormod_GK,

Have you solved your issue? If you have, could you kindly mark my answer?

Regards,

Jimmy Tao

[Tormod_GK]

Yes, but was just hoping for a different solution 🙂