cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ganesh_simhadri Frequent Visitor
Frequent Visitor

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?

4 REPLIES 4
KMW Regular Visitor
Regular Visitor

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

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

ganesh_simhadri Frequent Visitor
Frequent Visitor

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. 

Hamlet Frequent Visitor
Frequent Visitor

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

I have the same kind of error

 

"his expression refers to a Relationship object named '31445cef-2400-49fa-8c32-a0a250a394ce', which has an error."

 

I guess that is referred to this DAX:

 

FechasDax.png

Highlighted
arefossa Frequent Visitor
Frequent Visitor

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

I am experriencing similar issues only if the report is using an "On-premises data gateway". While using the personal gateway mode my report and refreshing seems to work as intended.

 

Has anyone managed to solve this issue in any way?

 

Best regards

arefossa