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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.