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