Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pjandliz
Advocate II
Advocate II

Cannot set up RLS against re-used datamodel used in a new report

Hi

I've tried researching this issue in this forum but am coming up empty.

I have set up a report/datamodel (with RLS set up within it) "MainReport" stored on my firm's PBI service, and have created another report "NewReport" which uses the first datamodel as it's primary data source (so this is treated as a Direct Query) and has a couple of Excel/Sharepoint files as additional tables.

 

My problem is PBI tells me the RLS doesn't roll through to my "NewReport", and when I try to set up RLS in "NewReport", I am not able to apply RLS to any tables from "MainReport" as they don't appear in the RLS table list section.


My RLS in "MainReport" is applied to a staff table, so I've attempted a work-around by duplicating this staff table in "NewReport" & relating it to the staff table in "MainReport" (as 1:1) and applying RLS to the "NewReport" staff table, however if I try to test this via the "NewReport" datamodel's 'Test as Role' security option, I get a 'Something went wrong. Not Supported' error message suggesting this is not possible.

 

Without the ability to test the new RLS via the "NewReport" datamodel's Security, I've no idea whether my workaround actually works or not.

 

Have I just missed something or is there something else I can try / change to get this to work?

This is my first attempt to 're-use' a datamodel and to get to this point and now find out the RLS doesn't 'roll through' and is so problematic to set up is quite frustrating, especially with a deadline looming.

 

Many thanks in advance. 

1 ACCEPTED SOLUTION
pjandliz
Advocate II
Advocate II

Yes, I had come across these limitations but was hoping there was some workaround that would help.

We had brought the original semantic model into another report and added to it a set of Excel tables. With this saved as a new semantic model, the RLS was no longer available.

 

We subsequently reverted back to just using the original datamodel and the RLS was then available.

Thanks for your time to reply Amit.

View solution in original post

2 REPLIES 2
pjandliz
Advocate II
Advocate II

Yes, I had come across these limitations but was hoping there was some workaround that would help.

We had brought the original semantic model into another report and added to it a set of Excel tables. With this saved as a new semantic model, the RLS was no longer available.

 

We subsequently reverted back to just using the original datamodel and the RLS was then available.

Thanks for your time to reply Amit.

amitchandak
Super User
Super User

@pjandliz , RLS is supported on the base dataset, if you try to use the same, you will not be able to set RLS again.

 

Also, consider these limitations

 

  • The Test as role/View as role feature doesn't work for DirectQuery models with single sign-on (SSO) enabled.
  • The Test as role/view as role feature shows only reports from semantic models workspace.
  • The Test as role/View as role feature doesn't work for paginated reports.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#considerations-and-limitatio...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.