Last Refresh Meaasure are different PBI Desktop , PBI Service

[Chanleakna123]

1st Pic : in Power BI Service 

2nd Pic : in Power BI Desktop , the right time should be follow Power BI Desktop 

this is M Code i'm using : 

let
TodaysDate = DateTime.From(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),10)),
#"Converted to Table" = #table(1, {{TodaysDate}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last Refresh Date Time"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Last Refresh Date Time", type datetime}})
in
#"Changed Type"

This is calculation i'm using : Last Refreshed (Local) = VALUES ( Query2[Last Refresh Date Time] )

team , there's sth between power BI Desktop and service , any solution on this ? 
I read the articles but find no right result. 

[v-shex-msft]

Hi @Chanleakna123,

Current power bi service will convert all datetime to UTC format, I think your issue should related to it.

The simply solution is switch your datetime to UTC and manually add offset to fix up datetime after finish calculation.

Reference link:

Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop

Regards,

Xiaoxin Sheng

[Chanleakna123]

hi @v-shex-msft , so how can i adjust it ? 

Can you help me on this ? 

[v-shex-msft]

Hi @Chanleakna123,

You can add a custom column with  UTCNOW function and timezone offset to force modify datetime to specific timezone datetime.

UTCNOW Function (DAX)

For example:

Fixed Local Now =
UTCNOW () + TIME ( 8, 0, 0 )
//offset: my timezone +8

Regards,

Xiaoxin Sheng