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...
Dear v-qiuyu-msft ,
Thank you for your message. I checked that my version is the latest available (2.76.5678.782 64-bit);
I noticed that your Replace value screen is different than the one I have, is there a reason? (you have the option to choose the data format on the left, which I don't have).
I am anyway getting the error using the "Replace Values" button in the ribbon and it is easily reproductible (dataset coming from SAP). Even with a datatable, it happens (and it is even worse as there is no way to avoid the "auto-conversion-to-date-format");
Thank you for your support,
David