cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xabit Frequent Visitor
Frequent Visitor

After desktop update dates display wrong format

I updated Power BI Desktop to the latest Feb release and when I click 'See Records' dates display mm/dd/yy hh:mm:ss, this only occurred after the update. Prior datetimes showed correctly. Funny thing is if I edit queries dates show correctly. Locale is set to Australia and my regional settings are fine.

The date format options I have under modelling don't give me the same format I had before the update.

Any ideas?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
cmcilwain Visitor
Visitor

Re: After desktop update dates display wrong format

Same issue here - after Feb desktop update, date formats changed from dd/MM/YYYY hh:mm:ss to MM/dd/YYYY hh:mm:ss even with regional settings on. None of the available date formats will restore the original format.

 

Date formats in the query editor still display correctly.

 

Rolling back to the previous version fiixed the problem.

 

 

View solution in original post

5 REPLIES 5
Highlighted
cmcilwain Visitor
Visitor

Re: After desktop update dates display wrong format

Same issue here - after Feb desktop update, date formats changed from dd/MM/YYYY hh:mm:ss to MM/dd/YYYY hh:mm:ss even with regional settings on. None of the available date formats will restore the original format.

 

Date formats in the query editor still display correctly.

 

Rolling back to the previous version fiixed the problem.

 

 

View solution in original post

xabit Frequent Visitor
Frequent Visitor

Re: After desktop update dates display wrong format

Thanks. I'll try rolling back now and advise how I go.

 

Would be good if MS can look at this so we don't have to go changing datetime formatting. 

astewart18 Frequent Visitor
Frequent Visitor

Re: After desktop update dates display wrong format

Same issue here, Australian regional settings are ignored since the February update in Power BI desktop.

 

Everything is fine once I publish to the online service, so I won't roll back, just live with it while I develop the reports. I am very interested in the UTC date and time functions now available, as I want to have reports updated by the service to show the correct timezone relative to my readers, not whatever time the hosting server has set.

 

I was expecting to be able to retire my current solution for getting a consistent last update time on reports, but in fact the UTC functions update when clicking on a slicer to change a selection, rather than when data is refreshed, so I can't use them for that (still good for displaying current time in a known timezone. 

 

FYI the approach I use is to get the date and time using a web query that specifies the required timezone as a datasource, that way it approximates the actual time that part of the update process ran.

 

In case anyone did not find that solution through crawling the web yet, here  is:

 

let
    Source = Xml.Tables(Web.Contents("http://api.timezonedb.com/v2/get-time-zone?key=GETYOUROWNKEY&format=xml&by=zone&zone=Australia/Melbourne")),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"status", type text}, {"message", type text}, {"countryCode", type text}, {"countryName", type text}, {"zoneName", type text}, {"abbreviation", type text}, {"gmtOffset", Int64.Type}, {"dst", Int64.Type}, {"dstStart", type number}, {"dstEnd", type number}, {"nextAbbreviation", type text}, {"timestamp", type number}, {"formatted", type datetime}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"formatted"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"formatted", "Data refreshed"}})
in
    #"Renamed Columns" 

 

You can get an API key at no cost for personal/non-commercial use from the nice people at https://timezonedb.com/ 

xabit Frequent Visitor
Frequent Visitor

Re: After desktop update dates display wrong format

Confirming that reinstalling a previous version resolved the issue for me, I found a great site that has download links as I couldn't find any on Microsoft's website:

 

https://zenatti.net/2017/07/04/power-bi-previous-versions/

 

xabit Frequent Visitor
Frequent Visitor

Re: After desktop update dates display wrong format

Thanks for the additional input astewart18. My data source is based in the UK so holds UTC 0 datetime stamps. I need to show timezone information local to the customer which I can do via a customer identifier. I therefore show a convert datetime based on this which is unaffected by the locale of the person viewing the report. I'm going to bank your post below though as it could likely come in handy in future (and I'm sure for others on the forum!). Thanks again.


@astewart18wrote:

Same issue here, Australian regional settings are ignored since the February update in Power BI desktop.

 

Everything is fine once I publish to the online service, so I won't roll back, just live with it while I develop the reports. I am very interested in the UTC date and time functions now available, as I want to have reports updated by the service to show the correct timezone relative to my readers, not whatever time the hosting server has set.

 

I was expecting to be able to retire my current solution for getting a consistent last update time on reports, but in fact the UTC functions update when clicking on a slicer to change a selection, rather than when data is refreshed, so I can't use them for that (still good for displaying current time in a known timezone. 

 

FYI the approach I use is to get the date and time using a web query that specifies the required timezone as a datasource, that way it approximates the actual time that part of the update process ran.

 

In case anyone did not find that solution through crawling the web yet, here  is:

 

let
    Source = Xml.Tables(Web.Contents("http://api.timezonedb.com/v2/get-time-zone?key=GETYOUROWNKEY&format=xml&by=zone&zone=Australia/Melbourne")),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"status", type text}, {"message", type text}, {"countryCode", type text}, {"countryName", type text}, {"zoneName", type text}, {"abbreviation", type text}, {"gmtOffset", Int64.Type}, {"dst", Int64.Type}, {"dstStart", type number}, {"dstEnd", type number}, {"nextAbbreviation", type text}, {"timestamp", type number}, {"formatted", type datetime}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"formatted"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"formatted", "Data refreshed"}})
in
    #"Renamed Columns" 

 

You can get an API key at no cost for personal/non-commercial use from the nice people at https://timezonedb.com/ 


 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,403)