Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated date wrong on Power BI Server

I have a "Last Refresh Date" field in my report that is populated from a manual query: let Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}) in Source   When I run it l...
Date and Time
Report Server
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    Based on my test, the DateTime.LocalNow() function will display in UTC time ignore the local region setting. So the report data is different from schedule refresh time. 

     

    Best Regards,
    Qiuyun Yu 

Grumelo's avatar
Grumelo
Advocate II
8 years ago

I had the same issue, date refreshed in Power Bi Desktop is not the same once calculate in Report Server Schedule Refresh.

 

I've solved the problem by adding my timezone

 

let
    Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}),
    #"LocalDateTime" = Table.AddColumn(Source, "LastRefeshLocal", each DateTime.AddZone([LastRefresh],1), type datetimezone)
in
    #"LocalDateTime"

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    That works great, thanks very much :)

     

    I'll just need to remember to adjust when daylight savings ends.