Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Please Help me With the Refresh time zone

please help me i have big problem about timezone refresh I want to set it to UTC + 7 when on desktop the time is correct , but when i

publish on power bi service its delay 7 hours 

 

please help 

on power bi service

on desktop 

its delay as in picture 

 

 

I user power automate to refresh 

refresh time on api

 

please help

 

thankyou in advance 

 

 

 

 

9 Replies

  • what's the reason for attempting a refresh every 15 minutes?  How long does an average refresh take?

    • Anonymous's avatar
      Anonymous
      Not applicable

      lbendlin because i need near realtime data for monitoring and this is the only solution to do with out fabric ,

      actually the avg time to refresh is about 5 min.

       

      • lbendlin's avatar
        lbendlin
        Super User

        fair enough.  Since Power Platform and Power BI/Fabric are always based on UTC it will be easier for you to adjust your processes to use UTC as well.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    I suggest you go and check the history of flow runs for the last 2 days and check if flow is triggering properly and if it is running every 15 minutes:

    Based on the configuration of your triggers, I don't think there should be any time zone issues involved, and there shouldn't be much of a latency issue, and by all rights your problem shouldn't be possible on January 2.

    Also, this is the Power BI Desktop forum, and there is limited technical support I can provide regarding Power Automate content. I suggest you can go to the Power Automate specialized forum to post for help, maybe there will be more professional engineers come to help you solve the problem.
    Microsoft Power Platform Community Forum Thread

    Best Regards,
    Dino Tao
    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

      Anonymous 
      i Just wonder where this error comes from is it power BI or Power Automate ,this cause the big problem cause the data will freeze after midnight untill 7.00 am UTC +7 then the data  will update to that day
      thank you for your help

    • Anonymous's avatar
      Anonymous
      Not applicable

      this is my problem that i try to explain

  • Desktop uses your own timezone but the services uses UTC so you're seeing a seven hour difference.  But where in your query do you need the date/datetetime?

    • Anonymous's avatar
      Anonymous
      Not applicable

      danextian I want to solve the problem that all data freeze after midbight till 7.00 am utc +7