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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Heinrich
Post Partisan
Post Partisan

Power BI RLS

Hello
I have done a Power BI Visual which shows limited data of a Dataset.

The user should have limited access to the semantic model with RLS.

He is only allowed to see the data from tables 1,2,3 which are in relation to "Alle...."

Heinrich_0-1738227741061.png

 

The RLS is configured: "Alle...." with condition "not empty"

 

Will the user only see data of 1,2,3 that is in relation with "Alle...."

 

Regards
Heinrich

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Heinrich,

 

Without knowing how you have setup the RLS I can't give a definitive answer however looking at the setup and your explanation, being the Alle table a dimension table where you filter you data the information from the fact table will be limited to the one that connect to Alle table, so yes your data will be limited to the one that you define, following the path of the of the filter propagation.

 

I would advice againts a many-to-many relationship but just a good practice.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
Heinrich
Post Partisan
Post Partisan

Hi @MFelix 
Thank you very much.
Great news. Thank you again
Regards
Heinrich

MFelix
Super User
Super User

Hi @Heinrich,

 

Without knowing how you have setup the RLS I can't give a definitive answer however looking at the setup and your explanation, being the Alle table a dimension table where you filter you data the information from the fact table will be limited to the one that connect to Alle table, so yes your data will be limited to the one that you define, following the path of the of the filter propagation.

 

I would advice againts a many-to-many relationship but just a good practice.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.