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.
