Forum Discussion

PowerBI53's avatar
PowerBI53
New Member
7 years ago
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 seconds level automatically.

 

Any help would be appreciated.

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi PowerBI53,

       

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


      Regards,
      Frank