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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
kb_barge
Frequent Visitor

Row level security on multiple tables linked to one table

Hi,
I have a customer table linked to three tables viz. Budget, Transactions and Open Orders through bridge tables.And there's both sided many-to-one relationships.

Hence, I am only able to turn on row level security filter for only one of the three tables.

 

For eg, when I turn on RLS filter on the sales table and I create roles, only sales get filtered and not budget or open orders.

 

Please tell me a workaround for this. Thanks in advance. 

4 REPLIES 4
Icey
Community Support
Community Support

Hi @kb_barge ,


Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.


Best Regards
Icey

Icey
Community Support
Community Support
kb_barge
Frequent Visitor

Hi @Icey ,
Thanks for your reply.
But the problem I have is kind of different. I suggest you to read the question again. 

Thanks

Icey
Community Support
Community Support

Hi @kb_barge ,

I think the end is similar.

If you don't mind, please give me some sample data, I will test it specifically.

 

Best Regards,

Icey

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.