cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
uulutas
Regular Visitor

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

Greetings,

 

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

 

uulutas_0-1608847629485.png

 

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.

 
 
2 REPLIES 2
Jimmy801
Super User III
Super User III

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
Solution Sage
Solution Sage

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)

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors