Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table Relationships problem (Indirect Relationships)

Hi, 

 

I am working on a Power BI dashboard, and I am currently stuck trying to create the nessecary relationships between tables.

Below is the Table Relationship diagram that i have created:

 

The Date Table needs to be connected to the 'Projects Table (REAL)', 'Projects Table (REAL) (RISK)' & 'CO2' tables. They are linked by 'Year/Quarter'.

All the Projects tables neet to be linked to the 'Sites 2' table. They all link to the Sites 2 table by 'Site name'

The CO2 table also needs to be linked to the sites table by Site name as well, but for some reason that relationship between CO2 and Sites 2 wont activate, as there are indirect relationships. The error message that comes up is shown below:

 

Im not too sure what im doing wrong in this case, as it has worked before. 

Any help would be much apprecieated.

 

Thanks

 

Aruneesh

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    The Date Table needs to be connected to the 'Projects Table (REAL)', 'Projects Table (REAL) (RISK)' & 'CO2' tables. They are linked by 'Year/Quarter'.

    You should not do that. The tables must be related by the Date column.  If you don't have date level in your fact table, create a fake date column, for example "first day of quarter".