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

[danielmarques]

I started getting this error when I got my new computer. So, I changed the file Sources within each table. I thought it would be enough to solve the issue, but now I get this message saying We cannot convert a value of type Table to type Binary.

[v-junyant-msft]

Hi @danielmarques ,

Regarding the error message "We cannot convert a value of type Table to type Binary," it seems like there's a mismatch in the expected data format. When working with data in Power BI and Microsoft Fabric, it's crucial to ensure that the data types and formats are correctly aligned with the operations or transformations you're attempting to perform. For converting data types, specific methods and functions need to be used, ensuring compatibility with the source and destination formats.
Without detailed M function as well as sample data, it is difficult for me to help you determine what the problem is with the information available, can you provide more details?

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

[danielmarques · Accepted solution]

Hi @v-junyant-msft ,

Thanks for the reply. I ended up getting the help from a friend, and here's what we did to fix the error:

- We extended the Transform File Column (load all columns);

- On the inserted step, we renamed every single header. So it was "Transform File.OrderDate," we renamed it to OrderDate, and we did it for every column.

- We also double-checked every "Source" step to ensure the directory was correct since I recently updated to a new computer (and I think that's the main reason I get things a little messed up).