PowerQuery in Excel, data types

[excelfriend583u]

Hello, sometimes when I refresh my table and my query, I get an error message that "2023E"could not be converted into date format. I don't find any reason for this behavior. Maybe someone can help me. Thank you.

[v-junyant-msft · Accepted solution]

Hi @excelfriend583u ,

It looks like your raw data was converted to be presented in scientific notation, what does your raw data look like?
If your original data structure is the same as the data I tested:

You can directly convert the column to a date type directly when the column's data type is text:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Omid_Motamedise]

What is the query about, explain more 

[Einomi]

Hi,

Can you share some screenshot of your query and error so that we can look into it ?