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
I’m experiencing the same issue.
Two of my resources are .csv files stored in a SharePoint site, and another resource is a Microsoft List located in a different SharePoint site. Instead of transferring all the resources to a single site, I found a workaround that worked for me! Here’s what I did:
Let’s say your last step before the merge step is named X.
Between X and the merge step, add these two steps:
1) Redundant step: Y = X (this step does nothing just reference the last step before this step)
2) Condition step: Z = if true then Y else X (This condition essentially does nothing.)
After step Z, reference this step and continue with your workflow.
I’m not entirely sure why this works, but I discovered this workaround by chance. If anyone knows the reason behind this, please let me know!
B
M