Forum Discussion

Data_Analystz's avatar
Data_Analystz
Regular Visitor
3 years ago
Solved

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...
  • ppm1's avatar
    ppm1
    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