Forum Discussion
Relationship with date table not working
olivierlaloo Check to see whether or not the data type is date in the "Edit Query" section. I've run into this before and wasted a bunch of time because I didn't check there. My guess, is that it is still text in that section. (Load vs. Model, they both need to have the same datatypes for some reason).
olivierlaloo Check to see whether or not the data type is date in the "Edit Query" section. I've run into this before and wasted a bunch of time because I didn't check there. My guess, is that it is still text in that section. (Load vs. Model, they both need to have the same datatypes for some reason).
I attempted to change the data type in the query from the Transform Data window, but PowerBI still fails to correlate correctly with the calendar table. Do you have any other ideas on how to fix this? Is this something where the file or query is corrupted for some reason and the process has to be started over? Thanks.