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 can relate this with O365 password change. This affected 25% of all my reports published on Power BI Service.
If the report was refreshed from Power BI Desktop there was no error.
Why: unknown
Solution that worked: in Power BI Service / dataset settings / Edit Credentials - click on each to to update credentials.
This solved it for me. I think I saw it in another one of the replies.
I checked my credentials/sign-on settings. One of the SharePoint connections had a setting of "Private" while the other one had "Organizational."
For me, both are in the same parent SharePoint, but different subfolders. Changing the "Private" to "Organizational" sign-in solved the issue.