Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
5 years ago
Solved

Refresh DateTime not always works

Hi all,

 

I have a problem that not alway`s the last refresh datetime is vissible in my power bi service visual.(but well in refresh settings)

 

Let me show you:

 

►►This is the messure i have in the Power Bi desktop.

 

 

 

 ►►Power Automate trigger every hour to refresh the Power Bi service report.(thats works)

 

 

 

 ►►Also when i then look in Power Bi service => settings and by history refresh i see that also the model is well refresh every hour.

 

 

►► But when i then update/refresh the service report there is NOT show the last refersh.

 

 

 

What do i wrong?😂

EDIT:
I see now that i think that the refresh is oke but that the time is not right.

It is 2 hours in the past alway`s, so for Amsterdam it must be +2 hours.

 

EDIT2:
I changed the settings in power bi desktop like this now. Is that the right way?

 

Now i see the right time.


 

Need Help

12 Replies

  • Frixel's avatar
    Frixel
    Post Prodigy
    5 years ago

    mwegener 

     

    That's too bad that is is not to change in the service. i will use it in various reports...

    and when you let the .LocalNow() away from the formule 'DateTime.LocalNow() as datetime' coul`d  that be a solution?  

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      5 years ago

      Hi Frixel 

      Unfortunately no, you would need something with which you can specify the desired time zone.

      What is your data source?

      You could e.g. query the correct time from the SQL server.

       

      • Frixel's avatar
        Frixel
        Post Prodigy
        5 years ago

        Hi mwegener 

        The data source are mostly from .xls and .csv sheets from OneDrive