Last refresh shows wrong local time

Hi Anonymous 

In your query you get refresh date and add 0.08333333 in your datetime.

Then I get a new datetime which equal to my correct time +2.

So 0.08333333 equal to 2 hours, so your correct time is my correct time +1 = datetime +0.08333333/2(0.041666665).

If you want to get the last refresh time, you can try this query.

let
    Source = DateTime.LocalNow(),
    #"Converted to Table" = #table(1, {{Source}})
in
    #"Converted to Table"

For more details about correct last refresh time, please refer to blog and video as below.

Blog: Display Last Refreshed Date in Power BI

Video: How do you get a REFRESH DATE in your Power BI report???

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.