Thorny issue with relationships

Hi GMkk,

Curent you can’t achieve dynamic relationship mapping on power bi side. For your requirement, I'd like to suggest you add inactive relationship and dynamic switch based on filter selection and Dax expressions.

BTW, you can also try to only keep the major relationships in your data model table with star schema without add other relationships. These indirect relationship directly applied in the Dax expressions and not create fact relationship key mappings.

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Since you not want use UERELATIONSHIP function, you can also try to unpivot these fields into the attribute and value, then you can setting RLS filter based username to filter on the unpivoted records to achieve dynamic filter effects.

Dynamic Attributes In A Power BI Report 

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Regards,

Xiaoxin Sheng