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

5 REPLIES 5
rohit_acharya
Frequent Visitor

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.

arefossa
Advocate I
Advocate I

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

Hamlet
Frequent Visitor

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

Anonymous
Not applicable

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

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.