Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Matan

BUG: Error in local time display

Submitted by on ‎04-18-2023 12:44 AM

Hi,

 

  • 2 identical workspaces: PPU and PRO.
  • 3 same object in each: DATAFLOW, DATASET and REPORT.
  • Both DATAFLOW containing the same QUERY for "Last Refresh" parameter. which is identical.
  • REPORT in PRO workspace showing the currect Local time in ISRAEL, while the REPORT in PPU workspace showing the worng time (-3 hours).
  • SAME issue in DESKTOP version.

DATAFLOW PPU:

Matan_0-1681803645019.png

Matan_4-1681803751378.png

 

 

DATAFLOW PRO:

Matan_2-1681803729579.png

 

Matan_3-1681803741624.png

 

REPORT PPU:

Matan_5-1681803778716.png

 

 

REPORT PRO:

Matan_6-1681803788615.png

 

Status: Investigating

Hi @Matan ,

By my test, the code you provided also got wrong value. I modify the code like this:

let
    Source = DateTime.AddZone(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()),-8,00),
    #"Converted to Table" = #table(1,{{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last refresh"}}),
    #"Changed column type" = Table.TransformColumnTypes(#"Renamed Columns", {{"Last refresh", type datetime}})
in
    #"Changed column type"

The "-8,00" means my timezone is UTC+8, you can change the value according to your timezone.

 

Best regards,

Community Support Team_yanjiang

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yanjiang-msft
Community Support
Community Support
‎04-18-2023 11:53 PM
Status changed to: Investigating

Hi @Matan ,

By my test, the code you provided also got wrong value. I modify the code like this:

let
    Source = DateTime.AddZone(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()),-8,00),
    #"Converted to Table" = #table(1,{{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last refresh"}}),
    #"Changed column type" = Table.TransformColumnTypes(#"Renamed Columns", {{"Last refresh", type datetime}})
in
    #"Changed column type"

The "-8,00" means my timezone is UTC+8, you can change the value according to your timezone.

 

Best regards,

Community Support Team_yanjiang

Idea Statuses