Forum Discussion

Balaji_Pandiyan's avatar
Balaji_Pandiyan
Regular Visitor
5 months ago
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
Need Help
  • rohit1991's avatar
    rohit1991
    5 months ago

    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.

rohit1991's avatar
rohit1991
Super User
5 months ago

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.