Forum Discussion

epaez's avatar
epaez
New Member
6 years ago
Solved

Time error in data in automatic refresh

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  in the report.  When I update from PowerBi desktop, a...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi epaez ,

 

You may enter into Query Editor, go to Add column ->Custom column,  adjust the timezone for the DateTime field using DateTimeZone.SwitchZone 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 & Apply".

 

DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-5 , 0)

 

 

 

 

 

 

You can learn more:

 

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

                                     https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328

                                    https://radacad.com/solving-dax-time-zone-issue-in-power-bi

 

Best Regards,

Amy 

 

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.