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.   Mos...
Need Help
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