Forum Discussion

DagmaraG's avatar
DagmaraG
Frequent Visitor
3 years ago

Last Refreshed Date based on refresh schedule in Power BI Service

Hi!

 

I want to show on a report the Last Refreshed Date.

I want to see when my report was refreshed in Power BI Service, based on schedule refresh. 

 

I have used Power Query, created new table with a code:

 

= DateTime.Time(DateTime.LocalNow())

 

but it shows only a date when I manually click on refresh in Power BI.

After publication in Power BI Service, the date is not changing, when the scheduled refreshed was performed. 

 

What I need to do?

Need Help

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

    Hi DagmaraG ,

     

    There's broadly two ways to achieve this:

     

    -1- In Power Query, create a new query that is just:

    let
    Source = DateTime.FixedLocalNow()
in
    Source

    Reference this value in your report via a card or similar.

    This will give an approximate refresh time, as it actually only records the time at which this specific query was refreshed.

     

    -2- Use the native refresh value provided in the dropdown at the top of the report in the Service:

     

     

    This gives a more accurate refresh time, as it shows the time that the entire dataset completed its refresh.

     

    Neither method will show only SCHEDULED refreshes. Rather both will show the date/time that ANY dataset refresh occurred, whether scheduled, pushed, or manual.

     

    In order to be able to display just the set scheduled times, you *may* be able to use the URL of your refresh schedule page in the Service and use it as an HTML/web source. However, I've not tested this and may be fraught with authentication and formatting issues.

    Either way, this also isn't going to give you an accurate representation of when a report was actually refreshed, due to MS load-balancing windows (+/- 15 mins) and actual processing time.

     

    Pete

     

    Pete

    • DagmaraG's avatar
      DagmaraG
      Frequent Visitor
      3 years ago

      hmm I tried this command, and then manually refreshed my dataset. 

      When the column is shown on a card it still does not show correct values. I compare it with the native refresh value provided in the dropdown

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        3 years ago

         

        Can you expand on "does not show correct values" please?

        What does this mean? Is it 4 seconds out, 10 hours out, just showing emojis?

         

        If you can provide screenshots of what your card shows in the Service, what the native refresh value shows, and also what your home timezone is please, that would help.

         

        Thanks,

         

        Pete