Type mismatch when refreshing date column

[shelbsassy]

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 which gave me a type mispatch.  But I tried to change the import data type to date but it only comes through as datetime and powerbi says it cannot have multiple time stamps of the same thing 00:00:00  Does anyone have any suggestions for how to resolve this?

[v-shex-msft]

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

[JConnol4]

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

[shelbsassy · Accepted solution]

Thanks for responding @v-shex-msft

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!