Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Time stamp with milliseconds

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

 

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

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

 

q1.PNG

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.