Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In Power Query Editor, when you change the Type of DateTimeOffset to DateTime Power BI just truncate the Offset, instead of converting it.
Example,
Source in DateTimeOffset:
16/10/2018 15:58:15 +01:00 |
After Changing the type to DateTime:
16/10/2018 15:58:15 |
Expected Result:
16/10/2018 16:58:15 |
If you do the same for a date in the Z format it converts it correctly:
Source:
2018-10-16T15:58:14.9970789Z |
After changing the Type to DateTime:
16/10/2018 16:58:15 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.