Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Last Refreshed Date

Hello!

I have a report where I have the Last Refreshed Date displayed. The problem is that it's displaying a date for the future if it's published online. If I open it up on my desktop, it displays correctly. Any ideas of where to start to fix it? 

 

Here's the formula for the field in query editor:

 

 

As of right now, this report was last refreshed on 1/10/22, 7:33 am but in the report it's displayed as 1/10/22, 12:33 pm.

 

 

 

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous The date and time displayed is going to be the time for where your Power BI tenant is located so it sounds like you may need to account for a time zone difference. In the Service if you use the ? icon and choose About Power BI you can see where your tenant is located and adjust your time accordingly. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Greg_Deckler So to fix it, do I just subtract the difference or do I have to adjust the formula for the right time zone?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        You can adjust the browser language settings and the language settings of Power BI Service to see if this solves your problem without adjusting your formulas.
        Adjust the browser language to your local language and set the Power BI Service language to the browser default and try again.

         

         

         

        Hope it helps,


        Community Support Team _ Caitlyn

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