Forum Discussion
Show milliseconds from data source with Power Query
Hi, I'm using PowerQuery to import data that has a time column with the data in this format (as shown in the editor when I select a cell in that column): 19:56:40.0560000 (7:56:40 pm with 56 millis...
Thanks for the suggestion. But Time.From([Timestamp]) yields the same result - it displays without the milliseconds and I'm trying to get it to display in the power query cells with milliseconds. Ultimately I'll be doing math with those milliseconds.
I think you are presenting an XY problem.
Doing the math has nothing to do with the format you see in the Power Query cell. Using the duration type will allow you to see the milliseconds. Using the time type will not. But in either case, the milliseconds will be preserved in the value stored, so there should be no problem doing math.
If you need to see it exactly as you show for some reason, then give it a text type and just use the appropriate conversion functions when you do the math.