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 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    It's weird that the function displays the local time in the desktop program but not on the server. I know the web version is different, but I figured the server would function the same as the desktop software and use the regional settings (like the now() function in SSRS does). Especially since it is called "LocalNow" not "UTCNow".

  • gvg's avatar
    gvg
    Post Prodigy
    5 years ago

    3 years after - DateTime.LocalNow() still doesn't show correct time even on Power BI Desktop :((