table date column while export date and time format coming in csv file

[Balaji_Pandiyan]

in power Bi desktop table one column in date format (yyyy-mm-dd) while export into csv date and time format is coming (yyyy-mm-dd 00:00:00").. how to fix this error

[v-sgandrathi]

Hi @Balaji_Pandiyan,

Thank you @Kedar_Pande @cengizhanarslan @rohit1991 for your response to the query.

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

Your understanding and patience will be appreciated.

[Kedar_Pande]

@Balaji_Pandiyan 

In Power Query, change your date column type to Text instead of Date before export. That forces "yyyy-mm-dd" format without time. CSV exports always add 00:00:00 to actual dates. Text locks it down.

[cengizhanarslan]

CSV does not preserve Power BI visual formatting, so a Date column is often exported using its underlying datetime value. If you need the exported value to stay as date only, create a separate text column to be used in your visuals.

[rohit1991 · Accepted solution]

Hii @Balaji_Pandiyan 

Even if the column is displayed as Date (yyyy-mm-dd) in Power BI, the underlying data type may be DateTime, so when exporting to CSV Power BI exports the full value like yyyy-mm-dd 00:00:00. To fix it, convert the column to Date type (not DateTime) in Power Query or the Data Model, or create a new column using FORMAT([DateColumn],"yyyy-MM-dd") before exporting. This will ensure only the date appears in the CSV file.