A column's type in Power Query determines how it is interpreted, and the locale defines how numbers and dates are read: 1 234,56 or 12/03/2025 depend on the locale. Converting with the right locale avoids silent errors.
Example
Table.TransformColumnTypes(Source, {{"Date", type date}}, "fr-FR")