Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Unable to determine relationships between fields

Please help! I have this data model

with these relationships

I'm adding this table with these fields and I'm having no problems with relationships:

but when I add the PeriodID field of the cumulative flowonboardingOM table that is highlighted in the data model, I get the message "Unable to determine relationships between fields (Data cannot be displayed because Power BI cannot determine the relationship between two or more fields)" and the chart is no longer displayed correctly

Please could you give me an idea of how I can fix it since I need to relate the Accumulated OnboardingOM Flow tables that is by CodProduct and Period with the WebOM Flow table that is by CodProduct and Date.

Thank you!!!

3 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    I think you have to check your relathinships going from Calendario --> TableFlujoOnboarding... (highlighted table).
    Maybe there is a "problem" with direction of relationships.


    But I don´t know your model. It is just an idea

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Thank you!! Guided by what you said about the direction of relationships, I changed the entire data model so that it drains the data better and it came out 😄

    I leave the final model porsiacaso:

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    nice, glad to hear you had success with your approach