Issue for Sharepoint folder source with Append/Merge

[Alex_m]

Hello all,

Since a short time, I am facing an issue with PBI when I am using Sharepoint folder as my input data.

I am doing some manipulations on it via the editor and then I am trying to append or merge it with another query.
I am getting this error message: "Expression.Error: We cannot convert the value "[Binary]" to type Binary."

It does not seem to have any link with the error in question.

Did anyone already face this issue ? Is it a bug of the last release ?

Many thanks,
Alex

[v-yuta-msft]

@Alex_m ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[v-yuta-msft]

@Alex_m,

Please check if the format of data in sharepoint folder is same with format of data in another data source. In addtion, if the issue persists, could you please share some sample data? Do mask the sensitive data.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.