Forum Discussion

FILIPKACZMAR's avatar
FILIPKACZMAR
Advocate I
4 years ago
Solved

Connecting tables problems

Hello,

 

I have got problem with making connecions in Power BI, maybe someone could help me get though this:

 

I have got 4 data tables which can only be connected via date columns (calendar). But when I am making connections, only 2 of tables works, rest of them get error and dont work at all.

 

If someone knows the answer please contact me. Thank you all for help.

General Comment
Need Help
Show and Tell
  • davehus's avatar
    davehus
    4 years ago

    Hi FILIPKACZMAR , You have bi directional relationships from what I can see in your model and more than likely is causing conflicts. Can you create a date table and join them into the four tables and work it from there?

     

    Did I help you today? Please accept my solution and hit the Kudos button.

3 Replies

  • davehus's avatar
    davehus
    Memorable Member
    4 years ago

    Hi FILIPKACZMAR , You have bi directional relationships from what I can see in your model and more than likely is causing conflicts. Can you create a date table and join them into the four tables and work it from there?

     

    Did I help you today? Please accept my solution and hit the Kudos button.

    • FILIPKACZMAR's avatar
      FILIPKACZMAR
      Advocate I
      4 years ago

      Hello, I have changed connections. I made a calendar date table and connected to it the rest of the tables 🙂 

       

      Thank you for your time and help 🙂

      • davehus's avatar
        davehus
        Memorable Member
        4 years ago

        Thanks FILIPKACZMAR , Can you please accept my solution if it has worked for you . 🙂