Forum Discussion
Expression.Error: We cannot convert a value of type Table to type Binary.
Please help in resolving this.
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
How do you fix this same issue when dealing with a SharePoint list?
It turned out perfect
Can you please give further details,
- what is the data source that you are using
- Details steps of your Power Query code.
