Forum Discussion
Data_Analystz
3 years agoRegular Visitor
DateTime column is adding one hour automatically when imported
Hi Friends, I have column in SQL table which is actually date column but it is in NVARCHAR (MAX). Current value in SQL table is 2023-04-30T23:56:07.949+0000 After importng it in Power BI, b...
- 3 years ago
In the query editor, delete the existing Changed Type step and then click on the icon on left side of the column name and choose datetimezone.
Pat
ppm1
3 years agoSolution Sage
It is likely converting to your local timezone. Try converting it to datetimezone instead of datetime.
Pat
- Data_Analystz3 years agoRegular Visitor
Can you please help me how to do that? And I dont want the field t display timezone in my visuals
- ppm13 years agoSolution Sage
In the query editor, delete the existing Changed Type step and then click on the icon on left side of the column name and choose datetimezone.
Pat