Time error in data in automatic refresh

Question

Hi, I have a Power Bi with origin in a postgreSQL database in Azure, some tables has dateTime Fields and I used this to graph the data per day&nbsp; in the report.&nbsp; When I update from PowerBi desktop, all runs runs ok and my register and data of today appers good in Power BI web.But when I update from automatic shedulle, or refresh from the web or using flow (Power Automate), the report increase 5 hours to all the data... that means for example if I have some data of today at 10:21 pm, in the reports updated in automatically way or from the web appears as 15:10 pm, so, all the data registers with dateTime superior to 7:00 pm appers as data for tomorrow date.. somebody knows how to solve? I already try to change the time zone in the automatic refresh setup in web, but doesnt matter what time zone selected, always increase 5 hours to data. (my time zone is GMT-5).&nbsp;Thanks&nbsp;Desktop:&nbsp;Web (updated from Desktop)&nbsp;Web (Updated from web) or with Automatic Refresh Schedulled active&nbsp;

v-xicai · Accepted Answer

Hi epaez&nbsp;,
&nbsp;
You may enter into Query Editor, go to Add column -&gt;Custom column,&nbsp; adjust the timezone for the DateTime field using&nbsp;DateTimeZone.SwitchZone&nbsp;function in the new created column. Then select on this column, navigate to Transform tab, choose data type and select Date/Time/TimeZone, and click "Close &amp; Apply".
&nbsp;
DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-5 , 0)

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
You can learn more:
&nbsp;
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; https://radacad.com/solving-dax-time-zone-issue-in-power-bi
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Time error in data in automatic refresh

1 Reply

Related content

Automatics Refresh

Automatic refresh error

Data Refresh Errors

refresh error

Refresh error