convert in number probleme after append tables

[Anonymous]

Hello,

i have a probleme when i try to append 2 tables. the append work but when i applicate my request,

i have always the probleme "couldn't convert to number".

i try every think (parameter the region, change the type....) but nothing work. ca anyone help me

[Icey]

Hi @Anonymous ,

Are the possible reasons listed above the cause of your issue?

Best Regards,

Icey

[amitchandak · Accepted solution]

@youssef195 , there must be a message in detail or in a column that shows the error. Otherwise, you have to check the data type of each column and change the one that is different

reference how to handle the error in the energy query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
debugging problem
https://www.youtube.com/watch?v=OE6DPmKqN7s

[pranit828]

Hi @Anonymous 

Can you check the column which you are trying to convert, if there is a alphanumeric value in any column or if any blank column has a space or a number has a space before or after in that very column.

Ther has to be some part of the data in that column which has junk value.

[Pragati11]

Hi @Anonymous ,

I can't understand your problem as there is no enough description for it.

Add more details for us to understand it:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati