Forum Discussion
Solved
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.
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.