Date format after Export export

Hi fabio_abbiati ,

Have sumbited this issue internal to confirm it(ICM: 298872918), would update here as soon as possible if there is any progress about it.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi fabio_abbiati ,

Update from PG team:

The date used in the model is the short date that's based on the OS settings, as it as an asterisk. Date time format with an asterisk will reflect the date and time settings of the Operating System. Export to workbook is performed on Power BI Data Service, and the Operating System of the machine hosting the service cannot be the same as the Operating System on Client machines. Therefore Date Time format with an asterisk may give unexpected result. To guarantee the correct format, please use a static format without asterisk

Also, you can try highlighting the cells with date values and right click -> format cells -> pick the format they want.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.