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
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
In case this ever helps someone in the future.
I had this exact same error/issue. The solution ended up being aligning the privacy levels in the data connection setting in the workspace to "organizational" for both. I had two connections to two different Sharepoint sites - one with "Private" privacy level and one with "Organizational" privacy level. I changed the Private one to Organizational by going into the workspace, going to the Lineage view for the report, click on the data sourc which opens a right hand panel, which contains a "Go to settings" link, and changed it there.
After that I was able to refresh without issue!