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. 

Highlighted
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors