Forum Discussion

avulasandeep's avatar
avulasandeep
Helper III
8 years ago

refresh date in service

HI Everyone ,

 

here is  i have question  at powerbi Service level .

 

I  need the possibility of getting date  at service level in card .  i kept the  Date/Time in card Before clicking on refresh, it has to show Last  (date/time) ,

Ex: suppose if my last refresh date is on  25th June , when i open the report in service it has to show last refresh date (25 June 2018)

and when i refresh the report on 29th June it has to show (29 June 2018) in the card at service level. 

before  publishing  the date is like below image 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

After publishing the report from desktop :

 

 

 

 

 

 

 

 

 

 

 

 

I am using measure  query and measure :

 

Query :

 

let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source

Measure :

 

Last Refreshed (Local) = FORMAT(LASTDATE(Query1[LastRefresh]),"mmm dd, yyyy hh:mm:ss AM/PM")

 


Is that possible to show last refresh date before refreshing at the service level, please let me know?

 

 

Thanks 

sandeep

Need Help
Show and Tell
Tutorial Requests

4 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi avulasandeep,

    You mean to say that you are publishing every time to see the latest refresh time?

     

    You need not have to publish the report everytime you want to refresh the report

    You can set for scheduled refresh to your needed time frequency and hence after refresh your report will be refreshed

    • avulasandeep's avatar
      avulasandeep
      Helper III
      8 years ago

      i no need  schedule refresh i need the manual refresh  and want to know when is last refresh date  by seeing that  i will refresh the  report  every  time is that possible ??

       

       

      Thanks

      sandeep

      • Thejeswar's avatar
        Thejeswar
        Super User
        8 years ago

        As far as I know, only when you set schedule refresh the refresh times are stored in the Power BI Service

         

        When you set schedule refresh, you can get latest refresh time from Refresh History option in your Data Set settings

         

        When you don't set schedule refresh, then the latest time at which you published your report is the latest refresh time.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi avulasandeep,

     

    As the Power Query code is not re-executed after publishing report to service even you refresh the web page. While re-publishing the report to service, the Power Query is running again which will get the new "Refrehshed Date". So, in your scenario, you may need to configure gateway for dataset so that the Power Query can be updated.

     

    Regards,

    Yuliana Gu