Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |