Forum Discussion

SammiElPadre's avatar
SammiElPadre
Frequent Visitor
1 year ago

No connection found between tables.

Hey Everyone!

 

I'm running into the following problem:

 

In my data model, I've got a factless fact table.

 

To this factless fact table I'm trying to connect several dimension-tables.

 

Most are connected directly via a 1:1-Connection, the three on the bottomhave a bridge-table in between. The connection for the bridge table is set as following for all three tables. factless fact 1:n brigde table n:1 dimension. 

 

So, when I try to display the data contained in these tables (mostly Names, roles, areas etc.) in a simple table, I use the 1:1-Dimension as first, then I drop in de second dimension, everythings fine, too.

 

As soon as I drop in a third dimension, I recieve the message that no connection between the tables could be found.

 

Can you guys give me a hind why there no connection could be found? From my side everythings seems fine and via SQL I can connect erverything.

 

Kind regards

Sammi

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

    • SammiElPadre's avatar
      SammiElPadre
      Frequent Visitor
      1 year ago

      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

  • Sergii24's avatar
    Sergii24
    Super User
    1 year ago

    Hi SammiElPadre, from the first look I'd say that you have too many bi-directional relationships 🙂 

    Now let's move to testing:

    1. Make all connections one-way only
    2. Test filtering and expected results
    3. Turn on only 1 bi-directional relationship at a time
    4. Repeat tests
    5. Repeats steps 3-5

    General suggestion: try to keep the only the very-very-very limited number of bi-directional connections (and only if they are really-really necessary). It will help you to avoid a lot of headache.

     

    Good luck! 🙂

     

    P.S. if you think that turning them off is impossible, think out of the box: use PowerQuery to construct them in a different way by merging, using composite keys and etc. Try to simplify your semantic model as much as possible