Forum Discussion

fabio_abbiati's avatar
fabio_abbiati
New Member
4 years ago
Solved

Date format after Export export

Hi All,   I created some reports using Power BI Desktop where I have some "Date" fields formatted like DD/MM/YYYY:   When I view in my browser, I see the correct format DD/MM/YYYY:  ...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

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.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

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.

  • fabio_abbiati's avatar
    fabio_abbiati
    New Member
    4 years ago

    Thank you for this clarification, this is what I need.

    Using a "date time format" without asterisk it works correct.

     

    Thanks

    Fabio