Forum Discussion
Date value changes to text on refresh of Power Query data - only for Excel 365
I have an issue where my date columns are transforming to numbers and defined as 'general' when I refresh the data. I've tried formatting the entire column as date and saving the file. The next tim...
1. Right click on target table(s).
2. Hover on the Table menu,
3. Select External Data Properties
4. Check the box next to "Preserve column/sort/filter/layout"