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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.