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
GAC
New Member

RLS on Semantic Model

Hi team, 

 

I have a model semantic published on PBI Service where  8 reports are using this model with base. I need apply RLS just on one report, how can I do this? I'm developing RLS rules onde PBI desktop and this Rules are applyng for all report, but I need it work on just one. 

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

After you connect to the semantic model, add your RLS table to that report's data model and wire it in.

View solution in original post

v-zhouwen-msft
Community Support
Community Support

Hi @lbendlin ,thanks for the reply, you are on the right track!

Hi @GAC ,

Regarding your question, it is possible to create an additional table in power bi desktop that stores the user information, link it to the data table and later publish it to the power bi service. For reports that do not require RLS, they can be created through the semantic model in the power bi service. For reports that require RLS, connect the previously published semantic model in power bi desktop. Create measure and use ‘USERPRINCIPALNAME’ function to filter the data based on the user information stored in the security information table. Finally, the report is published to the power bi service, and the report dynamically filters the data according to the logged-in users.

View solution in original post

2 REPLIES 2
v-zhouwen-msft
Community Support
Community Support

Hi @lbendlin ,thanks for the reply, you are on the right track!

Hi @GAC ,

Regarding your question, it is possible to create an additional table in power bi desktop that stores the user information, link it to the data table and later publish it to the power bi service. For reports that do not require RLS, they can be created through the semantic model in the power bi service. For reports that require RLS, connect the previously published semantic model in power bi desktop. Create measure and use ‘USERPRINCIPALNAME’ function to filter the data based on the user information stored in the security information table. Finally, the report is published to the power bi service, and the report dynamically filters the data according to the logged-in users.

lbendlin
Super User
Super User

After you connect to the semantic model, add your RLS table to that report's data model and wire it in.

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