Forum Discussion
Error: DataFormat.Error: We couldn't convert to Number. Details: #N/A
When I am trying to expand the column after merging two tables that have a common column and the same data type, I recieve the following error.
Somewhere in your code-country-region table in the Region field, you have an #N/A value. It may not be showing itself in the main table because Power Query doesn't evaluate every record when designing queries. Generally only the first 1,000 rows.
But when you merge, it forces PQ to do a more detailed analysis and this is showing up now.
In your code-country-region table, go to the last step and select Keep errors as shown:
That will show you the record(s) with the error(s).
Then either fix the data there by either filtering them out if those records aren't relevant, replacing it with null, or fix it in your source. Then remove the "Keep Errors" step once done trouble shooting.