Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataflows Last Refresh Date?

Hi,

 

How to show Dataflows Last Refresh Date in Power BI Report?

 

Thanks,

Lawrance A

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous,

    Sorry, I should have been clearer.

    You need to add the code to yor dataflow, so when the dataflows is refreshed it will give you the execution time. 

    Hope this helps

    Mariusz


7 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    HI Anonymous 

    Add this is M script that I use

    let
Source = #table(type table [#"dataflow last refresh"=datetime], {{DateTime.LocalNow()}})
in
Source

     Hope this helps
    Mariusz

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I tired the script but it showing current data time instead of Dataflow last refresh date.

       

      Thanks,

      Lawrance A

      • Mariusz's avatar
        Mariusz
        Community Champion
        7 years ago

        Hi Anonymous,

        Sorry, I should have been clearer.

        You need to add the code to yor dataflow, so when the dataflows is refreshed it will give you the execution time. 

        Hope this helps

        Mariusz