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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Is there a way to ignore data format errors and proceed with a query?

My raw data comes from a dataset that I cannot modify. When I try to load it into power query and use it in a query merge, I get a data.format error (for a certain column) that certain values cannot be parsed into dates. The thing is, I set the column type to "text" so I would assume there wouldn't be values that need to be parsed as dates... but I'm still getting that error. Is there a way to tell power query to ignore data.format errors? It would be a major pain to locate the values that are causing the issue because I have so many date and non-date values in that particular column.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

You can try “Replace Error” feature.

vstephenmsft_0-1691485289209.png

vstephenmsft_1-1691485302969.png

Replace null with errors.

vstephenmsft_2-1691485361783.png

The column is still in date type, and the error is replaced with null.

vstephenmsft_3-1691485367386.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
Anonymous
Not applicable

Hi @Anonymous ,

 

You can try “Replace Error” feature.

vstephenmsft_0-1691485289209.png

vstephenmsft_1-1691485302969.png

Replace null with errors.

vstephenmsft_2-1691485361783.png

The column is still in date type, and the error is replaced with null.

vstephenmsft_3-1691485367386.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.           

 

Syk
Super User
Super User

Are you merging into another table that has the column type set as date? Also, when you load data it likes to add a changed type step that tries to detect your data types. Experiment with removing this step as it may be trying to convert it to a date.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors