Forum Discussion

OliverO's avatar
OliverO
Helper III
7 years ago

Relationship problem

Hi I wonder if anyone can point me in the right direction?   I am building a model and am getting to the point where Power BI desktop accepts the relationships I have created, but when I start to ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Oliver,

 

1. What are the details of the error message? You can click the "See Details" in the visual.

2. How did you create the visual that is broken? The paths are based on the fields you chose.

3. Can you share a dummy sample?

 

Best Regards,
Dale

OliverO's avatar
OliverO
Helper III
7 years ago

Hi Dale

 

The error message is simply, "Can't determine relationships between fields.   Can't display the data because Power BI can't determine the relationship between two or more fields."

 

The visual is purely a table visual.  I am having issues with the same model with the matrix visual, but thought it would be easier to demonstrate the problem with a table visual.

 

At the moment, the data is coming in from a Filemaker database via ODBC.  I will try to make time to create a text file version, but I don't think I will be able to do that today unfortunately.

 

Many thanks for your help though

 

Ollie

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    How is raw_forecast related to OPCO_budget_lookup and how is OPCO_budget_lookup related to raw_timesheet?