Forum Discussion

s-mawass's avatar
s-mawass
Frequent Visitor
3 years ago

Data load and Refresh

Hi there,  I have loaded data into the Power BI desktop, and I would like to know if I can use Power Query or M language to save the last refresh date. In the next refresh, I would like to dynamic...
Need Help
Tutorial Requests
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Sami,

 

In Power Query, you can create a new query that is just:

let
    Source = DateTime.FixedLocalNow()
in
    Source

 

This will capture something *approximating* refresh time. It won't be exact as you can't tell where in the refresh plan this query gets refreshed, but it should be fine for most applications.

 

Pete