Forum Discussion

olivierlaloo's avatar
olivierlaloo
Regular Visitor
9 years ago
Solved

Relationship with date table not working

Hi All, I'm fairly new to Power BI and got stuck on something that seems so easy in tutorials, but on my project, haven been spending hours finding the reason why... So, i have created a new PBI base...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

God bless you, you saved my day 😄 😄

I almost wasted 2 hours figuring out why the date join is not working.. it was the datatype difference in Edit Query section..Thanks!