DataSource.Error: Microsoft Informix Client: Date could not be converted to month/day/year format SQLSTATE=IX000 SQLCODE=-1210 Detalles: DataSourceKind=Informix DataSourcePath=10.11.0.311:9089;pbase Message=Date could not be converted to month/day/year format SQLSTATE=IX000 SQLCODE=-1210 ErrorCode=0
I changed the regional settings to Englist(United Kingdom) and (United States) but the problem persit.
In both tables de column date have the format mm/dd/yyyy.
Hi @arolhaiser ,
Try to go into Power Query Editor.
1.Change the error field data type to text format.
2.Right click the Date2 column, select Using Locale.
3.The data type is changed to date format, and the local selection is the same as the text format.
4.After click OK, the results is as follows.
https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query
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 @arolhaiser ,
Try to go into Power Query Editor.
1.Change the error field data type to text format.
2.Right click the Date2 column, select Using Locale.
3.The data type is changed to date format, and the local selection is the same as the text format.
4.After click OK, the results is as follows.
https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query
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.
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
