Forum Discussion
Dashboard last refresh date shows in US format for users
- 9 years ago
I mean Browser Setting.
for Google Crome
1>go to setting
2>Advanced
3>Language
4>Add language
5>select You Want(eg. English (Australia))
6>Restart your Browser.
*It should Help*
It was changed in Chrome as I am using Chrome.
- Anonymous6 years agoNot applicable
A Solution that worked for me that I want to share on this thread.
I solved this by installing my local language pack English (United Kindgdom) into Windows Display language area of Windows 10 which then took me to the Microsoft Store to download the UK language pack which I had to find manually, but the direct link on the store is here
Steps to change it:
1) Windows key on Win10
2) Type Language into the search box
3) See the Windows Display Language drop down at the top of the screen, mine was set to English (United States )
4) Click the Add a Windows display language from the Microsoft Store
5) Find the language for your locale from all the langua
6) Click the Get button, it will download and install and you don't need locall admin rights on the PC
7) Logout of Windows 10, and Log back in
😎PowerBI date refreshes now show in the right date format
I suspect lots of other Microsoft services use this very buried setting for their local language and regional settings as well.
Cheers ScottJackson_UK
- mike_honey6 years ago
Memorable Member
I've also been wrestling with this issue on and off also - finally just fixed it.
If only there was some clear documentation from the Microsoft devs, instead of leaving the community to waste our time fumbling around ...
On my machine Windows only has English (Australia) as a language, so all of the solutions involving changing the Windows language did not seem relevant.
I'm using the Chrome browser for Power BI - not a Chrome fanboy generally, but it seems the most reliable for Power BI IMO.
So the solution in my case was fixing the Chrome language settings as shown:
I previously had the row showing just "English" set to display the Google Chrome UI. I don't recall that "English" entry ever being present previously - perhaps it's something a recent Chrome update has introduced.
HTH
- RoyceLithgo7 years ago
Helper I
In IE it was already setup as English (Australia).
- GilbertQ7 years ago
Super User
Hi there
The only other thing I can think of is if the locale was set at the time the PBIX file was created? - RoyceLithgo7 years ago
Helper I
I'm fairly confident that when it comes to Dashboards, date formats have been hardcoded to US standards.
Whatever locale could have been set during initial creation, would have been en-AU.
The regional settings in Power BI Desktop were already set to English (Australia).
The other thing i noticed with the last refresh time option on dashboard times is that it shows the time in UTC format. Seeing that these tiles are designed to be for the end user, this is not very useful.
I think i will abandon Dashboards altogether and build everything as report pages.
- GilbertQ7 years ago
Super User
Whilst it does appear that the dates are for the USA Locale, for my dashboards the last refreshed time is correct to my timezone.