Forum Discussion
Expression.Error: We cannot convert the value "[Binary]" to type Binary.
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.
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.
2 Replies
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-Lag0VOiTsdebug issue
https://www.youtube.com/watch?v=OE6DPmKqN7sHi 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.
