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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MaxSimes
Regular Visitor

RLS in Chained Datasets

RLS on Upstream Semantic Model
2 hours ago

Hi Hive Mind,

 

I have been wrestling with this for a few days and am not getting anywhere so figured it was tiem to ask.

 

I have  a semantic Model 'PEPI - NOHH' with RLS set up on the table 'Meterpoint Details'

 

this is working as expected and filters dwon the data on a report that is built from thos model.

 

 

I have now created a new report that is connected to this Model as an Upstream Semantic Model along with another Upstream Model.

 

MaxSimes_0-1708525241505.png

 

 

 

in this set up the RLS on PEPI - NOHH is no longer working, i cant set up RLS in Desktop as the Report is only using existing Semantic Models....

 

how can i achieve the ame RLS filtration with this setup or is this not possible?

 

Thanks in advance

 

3 REPLIES 3
MaxSimes
Regular Visitor

Hi @lbendlin 

Let me try and give a bit more detail, we use this report emdeded in our Customer Portal, there is currently a report called PEPI - NOHH which is embeded and has been in use for a number fo years.

The PEPI-NOHH model has the following RLS filter

[CompanyID] = value(username()) ||
[HQID] = value(username()) ||
[REGIONID] = value(username())

 

The Username() is passed in as an integer value by our portal when the report is loaded.

I am developing a new report to replace the existing, using data from both the PEPI -  NOHH Model and the HH Data 2 Model.

If i log into our Portal as as user the PEPI - NOHH tables are not filtrering down based on the logic in the RLS filter on PEPI - NOHH. 

 

on that basis it appers the RLS of the "other models" is not being utilized

 

any thoughts would be most appreciated

You seem to be passing a userid that has "full access" on that RLS.

lbendlin
Super User
Super User

Your report will continue to utilize the RLS of the "other"  semantic models. Please describe what you mean by "no longer working".  How did you test?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors