Datamart Date formatting is in US (mm dd yyyy) and i need GB (dd mm yyyy)

[Anonymous]

Dataflow has date in GB format (dd-mm-yyyy) when loading into Datamart its getting stored / converted to US format (mm-dd-yyyy) so all my date are getting an error. how can i store the date format in dd-mm-yyyy in datamart?

i an getting an error when i load the dataflow into the datamart as the string is invalid.

any help pleasE?

[Anonymous · Accepted solution]

Hi @Anonymous ,

We have reported your issue and have submitted to internal icm 337758193 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

BTW:

This reply will be accepted as a SOLUTION so that users with a similar situation to yours are aware that MS has acknowledged the problem. I will continue to follow any subsequent progress in this thread until the issue is actually resolved.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]

Hi @Anonymous ,

Would it help if you tried changing the browser language to GB and then set the language of Power BI Service to the browser default and try again?

How to change the date Format in the Power BI Service | NFORM | Perth, Australia

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

Thank you for you feedback.

No luck - still the same issue.  its very annoying, have you experienced this issue too and your suggestion worked?