Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Last Refresh date time

Hi

 

I want to show the last refresh date and time from Power BI service on my Power BI report. Is it possible to do.

 

 

I am scheduling auto refresh of report at 9 am and 1 pm, this field "Refreshed" is changing after refresh. I want to pick this value and show on report. I am planning to use CARD visual in Power bi desktop and want to show "REFRESHED" value from Power bi service so after Publishing report, Power BI service can show refreshed value.

3 Replies

  • gpiero's avatar
    gpiero
    Icon for Skilled Sharer rankSkilled Sharer

    Anonymous 

    Hi,

    tiles pinned in your dashboard could display the last refresh.

    You will find the option selecting the three dots menu, at right top (if I remember well... at the moment I do not have access on Pro version)

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable

      I want to set up on report not on dashboard.

      • gpiero's avatar
        gpiero
        Icon for Skilled Sharer rankSkilled Sharer

        Anonymous 

        Hi

        In a desktop version the following solution works.

        Please check how it works in PBI Pro

         

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

         

        Sorry but I am not able to check since I haven't any Pro licence available.

         

        Regards