Reply
Frequent Visitor
Posts: 16
Registered: ‎06-14-2018

This expression refers to a Relationship object , which has an error.

Hi I am getting the following error on the created column when i am refreshing the data. I did not have nay issues before the refresh.

 

Following is the code snippet 

 

Billable = if(
not(
ISBLANK(
LOOKUPVALUE(Task[isbillable],Task[id],SheetsAll[id])
)
),

LOOKUPVALUE(Task[isbillable],Task[id],SheetsAll[id]),
LOOKUPVALUE(Jobs[isbillable],Jobs[id],SheetsAll[id]))

 

Following is the error 

This expression refers to a Relationship object named '902a1ae2-e95d-420e-9f24-eae5303c57d8', which has an error.

 

Can some one help me in debugging this issue?

KMW Regular Visitor
Regular Visitor
Posts: 17
Registered: ‎06-07-2018

Re: This expression refers to a Relationship object , which has an error.

Do you still have an active connection to your data source?

Frequent Visitor
Posts: 16
Registered: ‎06-14-2018

Re: This expression refers to a Relationship object , which has an error.

Yes, I was able to get data for the columns mentioned in DAX.