Power Query - Table Formatting

[jaihawk8]

This is a table that my information is returning. Each time it's updated, some of the information coming back keeps the date format, but some of it doesn't. Here's an example:

In looking at the table, the format for the cell goes from "Short Date" to "General".

This is the format of the table:

In the query, it is selected as Date:

What am I doing wrong?

 

[saboh12617]

Hello,
I think you should uncheck "preserve cell formatting", as the query should return formatted values, and they are correctly formatted in the query.

 

[jaihawk8]

Hello,
I think you should uncheck "preserve cell formatting", as the query should return formatted values, and they are correctly formatted in the query.

Doing that turns all of the dates to General when I refresh.

 

[saboh12617]

Did you apply the date format to the whole row? If so, i do not know i'm sorry.

 

[jaihawk8]

Did you apply the date format to the whole row? If so, i do not know i'm sorry.

The whole column, yes.