Date format changing desktop to web

CC: WillT 

Hi all,

Fixed it!!!! - Well my DBA colleague found the solution.

The reason it was working for some users and not others is the following:

When a user had their default language set to English UK then their language setting in Power BI would remain unset.
When a user had their default language set to English US then their language setting in Power BI would get set to English.

(This is why we had some users working properly)

There appears to have been an update on the Power BI Service recently that allows you to set the language setting to respect the browser settings again.

(This was not the case earlier this year http://community.powerbi.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-English/td-p/126262 )

This means, you can now correct your language in your browser and then setting the Power BI Service language to default and the issue should be fixed.

To do this:

Change your browser language to English (UK) (or relevant language).

IE: Set IE Default Language (same for IE 11)

Chrome: Set Chrome Default Language

Then, in the Power BI Service, under Settings > Language, set it to Default (browser language).

Choosing this means the dates in my reports are now in the correct format, DD/MM/YYYY. :smileyhappy:

Thanks,
Jon

Twitter: @JonBaylis