Forum Discussion

shelbsassy's avatar
shelbsassy
Resolver I
8 years ago
Solved

Type mismatch when refreshing date column

I tried updating my table with 2017 dates to include 2018 dates and when I tried refreshing the table I get a type mismatch.  In power bi the format is date but when I import into sql I used varchar ...
Need Help
  • shelbsassy's avatar
    shelbsassy
    8 years ago

    Thanks for responding Anonymous

    I did some more research and was able to do an alter table alter column in sql to change the value to date and then power bi brought it in perfectly.  Thanks!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI shelbsassy,

 

What is the format you stored date value, can you share some example?

In my opinion, I'd like to suggest you use text format to stored these date, then use Date.FromText to convert format.

 

BTW, I don't think power bi will support analysis timestamps as date, if you use any specific timestamps to store date value, you need to convert timestamps to normal datetime before you change column type.

 

Regards,

XiIaoxin Sheng

  • shelbsassy's avatar
    shelbsassy
    Resolver I
    8 years ago

    Thanks for responding Anonymous

    I did some more research and was able to do an alter table alter column in sql to change the value to date and then power bi brought it in perfectly.  Thanks!

  • JConnol4's avatar
    JConnol4
    Frequent Visitor
    7 years ago
    Hi guys

    I am having this issue and can’t figure out why. Do you have any ideas at all please?

    I have appended two queries (new data for additional periods) but I am getting mismatch error when I refresh.

    Was the solution to save dates as texts? When you say this what do you mean please?

    Thanks again

    James