Forum Discussion
Query references relationship between column and local date table which depends on invalid column
Hi,
I've having trouble correcting an error which occurs when my dataset refreshes in online service. The error message is: "The query referenced a relationship between 'Study'[_75RTEActual] and 'LocalDateTable_87fbfb9c-96f2-4a84-a5b3-53db3f26f2bc'[Date], which depends on a column that is not in a valid state."
What's strange is that the report behaves correctly in PBI desktop and in PBI service when it is initially published. However, as soon as onedrive refreshes, or scheduled refresh happens, the error occurs.
The error seems to be similar to the one reported here, but for dates: https://community.powerbi.com/t5/Service/The-query-referenced-column-which-depends-on-another-column/m-p/166866
As suggested in that post, I have tried changing the datatypes of the relevant columns and format of the measure, but without success. It seems like it must have something to do with the date hierarchy not being handled correctly in the service, but I've tried converting to a text and back again to try and avoid the local date table problem, again without any success.
The column in question depends on a measure - perhaps this is what is causing the issue? The measure returns the correct results in the desktop so I'm not how to troubleshoot it.
Any help much appreciated!
I solved this in the end - it had to do with using a mixed model and calling a direct query table in one of the column calculations on an imported table: works fine in the desktop, but not when refreshing in service.
1 Reply
I solved this in the end - it had to do with using a mixed model and calling a direct query table in one of the column calculations on an imported table: works fine in the desktop, but not when refreshing in service.