Lastly, if Power Query is failing to convert numbers due to mismatched decimal points and thousand separators, use the Replace Values option to swap the wrong separator (e.g., change ‘.’ to ...