Forum Discussion
Power Query Merge/Append "Expression.Error: We cannot convert the value "[Binary]" to type Binary."
So, I moved one of the excel files to the SharePoint where the other file was being stored and this error is not shown anymore.
From this, I'm assuming that its an issue (a compatibility issue of some kind) between the two SharePoint sites, as switching them solved the issue. Like I stated before, the privacy levels of both are set to 'Private' and the only difference that I could see is that in one SHarePoint site i'm a Member and in the other one, I'm the owner. Not sure if this is the issue.
So, work around 2 - Store the files within the same SharePoint site
Reason for the error? - Still a mystery
Maybe this is caused by some data error in your Excel files. Would you please share some data for further testing?
xzmiche Thanks for replying!
I don't think its an issue in the excel files. I had the files kept in different SharePoint sites earlier, now I moved the file itself to one unified SharePoint site and now it works (All I did was move the same exact file to one of the 2 SharePoint sites, no other changes in or on the file).
It's some issue when the file is being stored in the different SharePoint sites, I dont know why still.
There is no error in your data
The solution above works for me and many others
It might be Power Query trying to do smart things on Sharepoint Excels. Smart things that have a bug inside.
When separating the query in halves, it works, so the problem is definetily in power query
