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