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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Orstenpowers
Post Patron
Post Patron

Dynamic RLS does not work due to 2 relation paths that conflict with each other

Dear all,

 

I am trying to setup my first dashboard with Dynamic RLS, but after some good progress I am struggling now.

When looking into my file more precisely, I recognized that a number of visuals was not displayed as expected.

For the concerned visuals, I got following message:

 

"Die Daten für diese Visualisierung wurden nicht gefunden.

Es wird erwartet, dass Verknüpfungspfade eine Struktur bilden, aber die Tabelle "SALES_DATA" umfasst zwei Verknüpfungspfade zur Tabelle "AD_Germany": "'SALES_DATA'->'Sales Header'->'AD_Germany'" und "'SALES_DATA'->'ST_PRODUCT_GROUP'->'Budget_Sales_GER_nach_AT'->'AD_Germany'"

 

From the message above I understand that I need to get rid of one of these relation paths, but after several successless tries, I hope that this community can help me!?
When looking into my relations, it looks as follows.

 

SALES_DATA(Order No)   -->   Sales Header(Order No)

Sales Header(Sales Rep (Order))   <-->   AD_Germany(Sales Rep(Order))

 

SALES_DATA(Sales Statistics Group)   <--   ST_PRODUCT_GROUP(Sales Statistics Group)

ST_PRODUCT_GROUP(PG_TOTAL)   <-->   Budget_Sales-GER(PG_TOTAL)

Budget_Sales_GER(Sales Rep(Order))   <--   AD_Germany(Sales Rep(Order))

 

From my knowledge, these paths are necessary to illustrate everything I need. When just looking at it in PBI, evrything works fine, but as soon as I test a role, several visualizations are showing the error message mentioned above.

 

What do I need to do in order to get the model started correctly? Looking forward to your proposals I remain

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

Power BI is not Qlik. In Power BI you can only have one active relationship between any two tables in the data model. Review your designations of dimension and fact tables, review the arrow directions, and adjust the data model to adhere to the star/snowflake principles.

 

All these bidirectional relationships need to be challenged.  Only use them if you absolutely must.  Use CROSSFILTER in measures to overrride temporarily.

View solution in original post

abpgupta
Continued Contributor
Continued Contributor

When security is concerned, avoid using many to many join. You can create bridge table to pass correct value to tables. Power BI works better with star schema. 
Dynamic RLS conceptually marks a row true or false. Write DAX to mark  true for a row each specific table can be alternate option. 
If you want to have cross filter functionality, you can create DAX and add on individual visuals as filter to pass values from one fact to them.

View solution in original post

2 REPLIES 2
abpgupta
Continued Contributor
Continued Contributor

When security is concerned, avoid using many to many join. You can create bridge table to pass correct value to tables. Power BI works better with star schema. 
Dynamic RLS conceptually marks a row true or false. Write DAX to mark  true for a row each specific table can be alternate option. 
If you want to have cross filter functionality, you can create DAX and add on individual visuals as filter to pass values from one fact to them.

lbendlin
Super User
Super User

Power BI is not Qlik. In Power BI you can only have one active relationship between any two tables in the data model. Review your designations of dimension and fact tables, review the arrow directions, and adjust the data model to adhere to the star/snowflake principles.

 

All these bidirectional relationships need to be challenged.  Only use them if you absolutely must.  Use CROSSFILTER in measures to overrride temporarily.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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