cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

arefossa Regular Visitor
Regular 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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 214 members 2,096 guests
Please welcome our newest community members: