Forum Discussion
Post ProdigyLast Refresh Meaasure are different PBI Desktop , PBI Service
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.
3 Replies
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 Anonymous , so how can i adjust it ?
Can you help me on this ?Hi Chanleakna123,
You can add a custom column with UTCNOW function and timezone offset to force modify datetime to specific timezone datetime.
For example:
Fixed Local Now = UTCNOW () + TIME ( 8, 0, 0 ) //offset: my timezone +8
Regards,
Xiaoxin Sheng
