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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Add millisecond precision for datetime columns in Power Query in Dataflows

As the title suggests, the millisecond precision for datetime columns is lost in Power Query when connecting to data via a Dataflow. This is an issue when needing the data at this level of granulaity. 

 

This isn't the case when connecting via Power BI Desktop though, where Power Query retains the millisecond precision. 

 

(This was mentioned already in this post on the Forums.)  

Status: New
Comments
v-chuncz-msft
Community Support

@richflan 

 

You may use Time.Second to view the millisecond.