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?
Do you still have an active connection to your data source?
Yes, I was able to get data for the columns mentioned in DAX.
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:
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?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!