Date/time Import as Text

[PowerBI53]

I have a date-time field in Excel where time is upto milliseconds. I would like to import it in Power BI either 1) as is - upto millisecond level or b) as a text string; currently it is turncating at seconds level automatically.

Any help would be appreciated.

[v-frfei-msft · Accepted solution]

Hi @PowerBI53,

You can disable the option "Automatically detect column types and headers for unstructed sources"in the settings and import the data again.

Regards,

Frank

[v-frfei-msft]

Hi @PowerBI53,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank