Date value changes to text on refresh of Power Query data - only for Excel 365

Copper Contributor

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 time I open the report and refresh the dates are converted to it's numerical equivalent.  In Power Query, the columns are seen as Date/Time; therefore, I changed it to 'Date' to see if the Time portion could be causing a problem.  That did not help.  I'm at a loss as to what the issue is.  This does not happen with Excel 2013.  I can't find any settings in Excel 365 that might be causing this.

3 Replies

@wowcow73 I have a similar issue. Did you ever work out a solution?

@wowcow73- I'm experiencing the same issue.  For me, it seems to loose formatting on all 'newly added' records at the bottom of the table.  As an interim solution, I created a macro to use Format Painter to copy the 1st row's format to the rest of the table.

 

** Is ANYONE from MICROSOFT monitoring this forum & issue?

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"

 

 

 

 

@wowcow73