Forum Discussion
zz00024
9 years agoRegular Visitor
Help! Errors when creating a table visual from multiple data sources
Hi everyone, I am now trying to create a table visual from multiple data sources. However, I keep getting errors when pulling one of the fields from one data source into my table....
MattAllington
9 years agoCommunity Champion
I've never seen that error before - must be something new. The issue is you have a classic many to many data model. Presumably your visual has a measue using the Tbl_Proudct table. You have bi direction relationships turned on so this should generally manage the situation. My best guess is that the filter on Assignment is conflicting with the filter on satisfaction (assignment is a bridge table in your model). Try removing Assignment from the visual and see what happens