Expression.Error: We cannot convert the value "[Binary]" to type Binary.

[Anonymous]

Hi Gurus, 

I am getting below error when trying to append two tables. Can you please help?

Expression.Error: We cannot convert the value "[Binary]" to type Binary. 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Based on the error message, you cannot combine binary files directly.

If these files are in the same folder, you can refer this document to combine binary files in power bi desktop:

Combine files (binaries) in Power BI Desktop 

If one file in local, one file in Sharepoint etc. , you can refer this simliar issue:

Underlying error message: We cannot convert the value "[Binary]" to type Binary 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , please check the datatype of the column. There seems to some issue with that.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s