Converting US date/time text to EU date format

[Johnweet]

I receive a spread sheet each month from 3 different world areas. I store these in a Sharepoint folder and then combne them in PowerBi so that i end up with one global repprt.  The spreadsheets contain raw data and are not manipulated in any way. The report I get from the US has a Date/Time field.  When i open it in PowerBi it sees it as text in the format MM/DD/YYYY HH:MM.  When i convert that field to Date / Time it gives me an error for any field where DD is bigger than 12.  It's obviously not realising teh date is in US format.  Any suggestions?     

[vicky_ · Accepted solution]

When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent. 
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).