Forum Discussion
Solved
Date/time Import as Text
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...
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
Community Support
Community SupportHi 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-msftCommunity Support
Community SupportHi PowerBI53,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank