Forum Discussion
Super UserDefault "Changed Type" in Excel
Yes you are right. Currently, Power Query automatically converts columns from Excel.CurrentWorkbook() to type datetime, even when the underlying data is a plain date. This is inconsistent with how external Excel file sources (Excel.Workbook(...)) behave, which correctly set columns to type date when appropriate. This behavior creates unnecessary cleanup work when working with tables in the current workbook. It would be incredibly helpful if users could globally configure the default data type mapping for date/datetime detection or choose to disable or override the Changed Type step defaults for Excel.CurrentWorkbook(). Please consider adding a setting (in Power Query or Excel Options) to control this behavior.
The final option:
There is no longer a dedicated Power Query UserVoice, but you can use Microsoft Excel Feedback Portal:
https://feedbackportal.microsoft.com/feedbackGo to Excel > Power Query, and click + Give feedback
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
Super UserYes, you can handle this behavior by modifying the time part of the values in the "Changed Type" step. While there isn’t a built-in setting in Excel Power Query to change the default type detection behavior directly, you can programmatically adjust the results after the "Changed Type" step.
If you find that Power Query assigns a datetime type but the time part is always 00:00:00, you can convert those columns to date using a conditional step. For example: