Forum Discussion

DevadathanK's avatar
DevadathanK
Resolver I
4 years ago
Solved

Power Query Merge/Append "Expression.Error: We cannot convert the value "[Binary]" to type Binary."

Hello Community!   I'm facing an issue in Power Query and can't seem to find a reason to why its happening. I could really use some advice on the reason to the problem.    This is the error I'm g...
Need Help
  • DevadathanK's avatar
    DevadathanK
    4 years ago

    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

  • DevadathanK's avatar
    DevadathanK
    Resolver I
    4 years ago

    Hi v-kelly-msft, Thank you for replying!

    I had seen this post before when I went through any material I could find to get the solution, I couldnt understand the solution offered in this post and futher more alot of comments were stating that its still a work around. I want to know why this problem occurs. 

    Currently I was able to find yet another workaround by storing the files on one single SharePoint site. However in a case where the files are stored say, in an SQL and Excel in SharePoint site, then such work around wont be helpful.