cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
112300576
New Member

Date time issues some custom and not custom in same column

112300576_0-1642516861522.png

 

Hi All - I have a date time field from a report - in the report from the system it comes into excel format. The date time field displays dates and times but some read as a custom format in excel and when i pull into power query it has an error reading the custom fields anyways around this? Thanks

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @112300576 ,

 

Probably I reproduced your error. 

vstephenmsft_0-1642734581415.png

Because your Power Query defaults to only recognize the date format of DD/MM/YYYY, but

the date format of the data source you provide is MM/DD/YYYY.

The workaround is to use change type with local.

vstephenmsft_1-1642734789362.png

Data type is Date/Time and locale is English(United States).

vstephenmsft_2-1642734816535.png

And OK.

vstephenmsft_4-1642734892562.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @112300576 ,

 

Probably I reproduced your error. 

vstephenmsft_0-1642734581415.png

Because your Power Query defaults to only recognize the date format of DD/MM/YYYY, but

the date format of the data source you provide is MM/DD/YYYY.

The workaround is to use change type with local.

vstephenmsft_1-1642734789362.png

Data type is Date/Time and locale is English(United States).

vstephenmsft_2-1642734816535.png

And OK.

vstephenmsft_4-1642734892562.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

112300576
New Member

see below the data on in column A on the right hand side is not being read correctly when loaded to Powerbi

 

112300576_0-1642518664625.png

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!