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.
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.