Need Help with Importing CSV with Strange Date Format

[CeiBob]

I have a CSV export from Intune which I am trying to import and the date format is causing me issues. I do not understand why this date format is not being picked up now, as it was previously.

When I look at the CSV document, the column 'Last Check-in' has a format which shows ##:##.# only, but when I click on it, the date /time shows in the field properly. The issue with this is Power BI does not recognize this date, and I would have to click on every single field to get it to convert from this odd format. If I do not convert it, Power BI doesn't know what to do with ##:##.#. 

I have included an example of the document below:

I do not know why Excel does not see the full format. When I look at the file in notepad, it shows the whole date / time for the cell, but microsoft products have been doing the ##:##.# format for some reason. This is causing me quite a headache also because I have no idea what this is called or why this is happening.

Is there a way to import this date column correctly into Power BI or convert it so Power BI can use it?

Thank you!

-CeiBob

[lbendlin]

Can you post a sample CSV?  Remove sensitive information.