Forum Discussion
table date column while export date and time format coming in csv file
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
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.
4 Replies
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.
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.
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.
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.
