Expression.Error: We cannot convert a value of type Table to type Binary.

Hi Bhavesh123 ,

This error occurs when your #"Sample File" is type Table and not type Binary.

In my sample data, if I want to use 1.xlsx as the sample file, then lick "Binary", it will generate the following steps, we need to delete the step "Imported Excel Workbook" to make it type Binary.

Then we can reference it successfully in the M code.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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