Connecting tables problems

[FILIPKACZMAR]

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.

[davehus · Accepted solution]

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]

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]

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