Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Last Refresh Visual Update in Web - How to make it work ?

Hi

 

I have made a "Last Refreshed" date & time visual in power BI desktop. Thus, each time i click refresh, the latest time & date will be updated in this visual.

 

However, when i publish my dashboard to power bi web and when data is refreshed (yes the latest data appears in dashboard), but the date and time of the last refreshed visual remains unchanged. How can i make it work ?

 

Please advise.

 

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Both refresh datatime are correct.

    They are the same datetime which are shown in different Time zone.

    You may refer to this blog for more details about showing datetime in Time zone you want:

    Display Last Refreshed Date in Power BI

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    If you want to show last refresh time in card visual, you can build a last refresh table in Power Query Editor by Query

    DateTime.LocalNow().

    In this column it will show the last data refresh datetime.

    Then build a card visual by this column and publish this report to service.

    Let's see the result.

    It is the same as the refresh success time in my refresh history.

    If you use Now() function in measure, it will update even you refresh the browser. So it won't show the data refresh time correctly.

    For more details about getting refresh datetime,you may refer to this video:

    How do you get a REFRESH DATE in your Power BI report???

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, yes i have done the same way that you have suggested. But there is a variance in time. Do you know why ?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous 

        Both refresh datatime are correct.

        They are the same datetime which are shown in different Time zone.

        You may refer to this blog for more details about showing datetime in Time zone you want:

        Display Last Refreshed Date in Power BI

         

        Best Regards,

        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

     

    Best Regards,

    Rico Zhou