Please Help me With the Refresh time zone

[firstcha]

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 

[danextian]

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?

[firstcha]

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

[v-junyant-msft]

Hi @firstcha ,

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.

[firstcha]

this is my problem that i try to explain

[firstcha]

@v-junyant-msft 
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

[lbendlin]

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

[firstcha]

@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]

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.

[firstcha]

@lbendlin currently its Utc

but it still delay