Time stamp with milliseconds

[Anonymous]

Hello,

I have an problem with date/time datatype.In one column we have date and time values with milliseconds.But Power bi ignores the milliseconds and rounding  the seconds.Please help for this problem.

Thanks,

Chunduri

[v-qiuyu-msft]

Hi @Anonymous,

Based on my research, the Power Query doesn't display the milliseconds in the preview table, but click on the cell, we can see the milliseconds value. It doesn't affect to calculate duration. See: https://social.technet.microsoft.com/Forums/en-US/87fec4b1-058d-4b57-8614-c05b99f163bd/subtracting-timestamps-which-include-milliseconds?forum=powerquery

Best Regards,
Qiuyun Yu