Forum Discussion
No connection found between tables.
Hi SammiElPadre ,
I'm sorry, but could you provide your pbix file? There are too many tables involved in your data model. Based on your description alone, I can't create a data model for testing myself, let alone find out the problem directly.
Best Regards,
Dino Tao
Hi Anonymous
I'm sorry but I can't provide the .pbix-file because the data involved is strictly restricted.
But I try to describe the problem:
I've got one table as central piece (factles fact), which basically only contains keys to the other tables.
Then I've got one dimension table which is connected via a 1:1 connection and two bridge-tables which are connected via 1:n. Every table has it's own keys which are matched to each other (e.g.: An entry from the 1:1-Table has keys to one or more entrys in the 1:n-connected tables).
When I drag a column from the 1:1-table and from one 1:n-connection in to a visual, everything works fine. But when I add a column from a second 1:n-table, the visual breaks down and tells me "No connection could be found between tables" (Hope I translated it right).
So basically: Table Visual with 1:1 plus one 1:n-Data Column works fine, but with multiple 1:n-Data there's apparently no connection possible.
kind regards
Sammi