Status:
New
Date format assumed earlier than expected in Power Query
When getting data from Excel source, the date format is assumed when the format of the column is set to Any (early stage of data preparation, see printscreen below) and the header of the column is "D...
Hi v-qiuyu-msft ,
I have successfully uploaded the picture (strangely enough, I was not able to do so yesterday).
Hope this will help to understand the point.
Best Regards,
David