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

[Bhavesh123]

Please help in resolving this.

[v-kkf-msft · Accepted solution]

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.

[YutingKimbley]

I have exactly the error and when I tried to delete the Import Excel Workbook step, it came up with this error:

[Syndicate_Admin]

It turned out perfect

[powerMeow]

How do you fix this same issue when dealing with a SharePoint list? 

[Syndicate_Admin]

Good afternoon

Unfortunately for us I am not getting to follow the steps you describe satisfactorily 😞

I delete the imported excel step and it keeps generating an error for me.

Additionally, where are you adding the M code? In the query / step "Origin"? You employ a custom function from what I see, what is this function?

Greetings and a thousand thanks in advance for the guidance,

I hope we will be able to resolve this issue.

[FarhanAhmed]

Can you please give further details,

- what is the data source that you are using 

- Details steps of your Power Query code.