Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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?
  • cmcilwain's avatar
    cmcilwain
    8 years ago

    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.

     

     

5 Replies

  • cmcilwain's avatar
    cmcilwain
    Regular Visitor
    8 years ago

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        astewart18
        Frequent Visitor
        8 years ago

        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/