Forum Discussion
Cannot convert a value of type Table to type Binary.
Anonymous ,
It is the property of the Binary data type. Refer the below ss for the example
Also in Microsoft Learn I see that Binary data type is not supported in Power BI and will throw an error if used
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
Regards,
Super UserHi Anonymous ,
In your M Query I see that you are adding a Custom Column with the content of the excel workbook. I assume the content of your workbook is a table.
To this custom column that holds the entire content of your excel workbook, you are assigning the binary data type, which can have only 2 values (1 and 0). This is the reason it is showing as error.
You should keep the datatype to preferably the same as the original content.
By the way, I am not really sure what you are trying to do here by adding a new custom column that contains the data of the entire workbook tables.
In case you are doing this to extract the tables from the workbook, you can do that by just clicking the table link in the first column to extract the respective tables
Regards,
Thanks for your reply.
If I click table link manually, can I get both 'Backup for previous data' and 'Weekly Data'?
As I recall, I have to choose one of them but I need both data in one single sheet.
- Thejeswar
Anonymous ,
Create two queries with one table in each one of them by clicking the table link and append these two queries to make a single table out of them.
This Final table you can use for any purpose
Otherwise you can click on the arrow at the top as shown above and expand all tables at once into a single table
However I would recommend this only if the two tables are identical
Regards,
I used to implement that way but two things make risk.
1. Too many dataset created so I wanted to make it as minimum as I can.
2. Manual clicking expands columns with specific column names such Column1, Column2, ...
this occurs error any small change in total number of columns.- Thejeswar
Anonymous ,
Post expanding, you have to promote header using the option shown in the below screenshot to get the right column names
If this helps, kindly mark it as a Solution! Appreciate a Kudo !