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
Try transforming the list of Binary Columns first, or if you have them in separate queries, Transform on each query first. If you have them in a list already, then it's:
List.Transform(NameOfBinaryColumn, each Csv.Document(_, [Encoding = 1252]))
Otherwise, just use =Csv.Document(NameOfPriorStep)
--Nate
Hi Anonymous Thanks for replying to me,
The way I connected the table is by using the 'Combine files' option present for the Binary data type column for the file. Then the automatic Transform queires are created and then I get the data in a table format. Its after this that I tried to merge the two tables.
I'm not certain if this method relates to this way, Let me try this method out.
I tried moving one of the excel files to the SharePoint site where the other one is being stored and now the error is not shown. I literally just copied the exact same file to the SharePoint site (no others whatsoever). Still have no clue as to why this issue is shown.