This expression refers to a Relationship object named 'dfc6b2ef-f0ad-416d-838a-02590b8bcb1c', which

[shaunb94]

Does anyone know how to solve this error? It has totally messed up my date table & all the pages in my report. 😵

[v-weiyan1-msft]

Hi @shaunb94 ,

I am not sure how your semantic model looks like.
I tried using the following data sample and the dax code you mentioned, but no error occurred.

The following reply from This expression refers to a Relationship object , ... - Microsoft Fabric Community is helpfulful.
"

Whenever there is an error in the primary key (of any table related to your table and not only the table in contention) this error pops up. Please ensure all the relationships with the Task and Jobs Table are valid. Whenever a cross table reference is made PBI checks the validity(no errors in the primary key) of all the relationships with that table. 

To be totally safe, Click on Modelling and then Manage Relationships, Check the validity of every relationship in this menu so that Relationship object based errors are avoided.
"

So please go to Manage Relationships and check the validity of every relationship in this menu.

Hope this works for you.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

I have not seen that error message before but sometimes there can be erroneous messages if relationships exist but the model is changed significantly.  Here are a few things to look into:

Have you got Auto/date time settings on? (you are now creating a dates table so that should be set to off).

Check relationships from the 'Manage relationships' button on the ribbon.  See if there is anything unusual in there.

Try creating the Dates table with CALENDAR not CALENDARAUTO