Forum Discussion
Datetime import issues
Hi RZ,
Did you mean these records are live changes when these records imported to power bi desktop side?
If that's the case, I'd like to suggest you use the static values on the sheet to import and update schedule, the live data may cause some issues to gett the latest data during import.
If you mean the records millisecond part has been rounded during the import operations, I'd like to suggest you use the text format to receive these records. (AFAIK, current power query datetime values seems not include milliseconds levels) Then you can extract millisecond part to a new column to keeping accuracy of these datetime values. (Power query will not apply any rounded operations with text values)
#datetime - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng,
The issue is the imported values are not the same as the original values.
The first screenshot shows a cell value of 10/04/2022 12:00:00 in excel. When this gets in PowerQuery it is displayed as the same in the column view but when you click on the cell you see that the value has actually become 10/04/2022 11:59:59.9990000. That I became aware when I used the a column to extract the Minute(). The funny thing is: I have a year worth of hourly data and the values before 10/04/2022 12:00:00 import fine but the ones after all have the same issue.
I found a way around that, I extract the minute in excel and import afterwards. But the behaviour is strange and would like to understand why that happens. But as of now I will double check my datetime imports.