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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi fabio_abbiati .

Check your regional settings.
MM/DD/YYYY fromat is usually designed for countries like US, the Philippines, Palau, Canada, and Micronesia.

All other countries use DD/MM/YYYY format.

If you want your date to be displayed in DD/MM/YYYY format, then change your regional settings.

If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.


Thanks,
Sanket