How to "enable load" on an Table with a table type column

[uulutas]

Greetings,

I have a table like this, it has a column called combined table that has another Table for each row:

It is created dynamically by reading an excel sheet containing table names, it reads the table name than read the table with that name from database. After creating this table, I use it to create other tables by referencing to this.

Now here is the problem, I want to "enable load" on this table, so I can refresh my data.

However when I enable load, when I hit "Save and close" on querry editor, it automatically adds this step at the end of it and deletes the main column:

Table.RemoveColumns(#"Replace errors", Table.ColumnsOfType(#"Replace errors", {type table, type record, type list, type nullable binary, type binary, type function}))

Because of the "type table" it adds, it removes my "Combined Tables" column completly.

And not enabling the load causes other tables failing to refresh since they are referencing to this.

What is my mistake here, am I approaching this wrong?

Thanks.

[Jimmy801]

Hello @uulutas 

why you would like to enable load this query, if you use it only as reference for other queries? Disable load and use it as reference, this should solve your problem. 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[StefanoGrimaldi]

you cant load referential results as data, you need to expand the table column by selecting the botton next to the name of te column on the right, this will display a list of column, you select witch you want to add to the data and them it will add those column, them should be no problem loading, but referential column dont load to the model (those are column you see like your example the fields values are in yello cause they have multiple results in it to expand)