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...
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!
