Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Solved! Go to Solution.
Hi @Anonymous ,
You can try “Replace Error” feature.
Replace null with errors.
The column is still in date type, and the error is replaced with null.
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.
Hi @Anonymous ,
You can try “Replace Error” feature.
Replace null with errors.
The column is still in date type, and the error is replaced with null.
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.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.