Forum Discussion
Merge Issue: Expression.Error: We cannot convert the value "[Binary]" to type Binary.
StefanoGrimaldi Thank you for your answer!
I am aware of the combine files functions and thought of using it for combining the Excel files. But I don't want to combine all of the files and filter based on the metadata. For that I need to merge the SharePoint file list with another table. And that destroys the "Content" column (as described above).Any ideas how to fix this? 🙂
StefanoGrimaldi Thank you for your answer!
I am aware of the combine files functions and thought of using it for combining the Excel files. But I don't want to combine all of the files and filter based on the metadata. For that I need to merge the SharePoint file list with another table. And that destroys the "Content" column (as described above).
Any ideas how to fix this? 🙂
thats because the content column isnt a data column, so there no data to combine or upload to the model, you need to extract first the data from thos binary column and them you can do any combination with others sources.
basically you will need to combine the excel files first, them add the sharepoint list content and them filter out the data for your final query, (all that need calculated tables on dataflows thats a primium capacity)
