Forum Discussion
fcerullo
Advocate I
Advocate IDataFormat.Error: We couldn't convert to Number but I am using Text columns
I get this error in both PowerBI Desktop Query Editior, and in Excel Power Query, when I am merging two queries. Each query only has a few columns and they are all formatted as Text. I have co...
Sometimes PowerQuery will try to help by adding a step of "Change Type" where it looks at the first 1000 rows and tries to determine if it is a number or text etc. Did it add a step like that when you loaded your data from the source? If so, you can just delete that step to stop it from trying to convert.
I have this exact error and when the files are expanded it assigned a type of text, which seems correct. Any other ideas of what could be going wrong?
I had the same issue. For me it was caused by the fact, that one of the key values i was merging two queries with wasn't a type number and there was a special character in it.
So i just converted it to a number and replaced the Errors.