Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Johnweet
Helper I
Helper I

Converting US date/time text to EU date format

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?     

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

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).

vicky__0-1670535671787.png

vicky__1-1670535682604.png

 

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

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).

vicky__0-1670535671787.png

vicky__1-1670535682604.png

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors