Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Combine multiple nested tables from XLM datasource

Hello,

 

 

I want to combine multiple nested tables from an XLM datasource.

Can I do this from the UI?

 

I am not sure that the correct term is "combine". The goal is to get the info one gets when clicking on the Table link, but for all tables at the same time.

 

Thank you

J

 

Expand nested tables.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous,

 

Nope, this function only works for list of table, when you use it in add custom column function(it contains 'each' Iterator), [Column Name] only means one item of list.

 

Please use #'previous steps'['column name'] to instead.

 

Sample:

 

Custom Column = Table.AddColumn(#"Added Custom", "Custom.1", each Table.Combine(#"Expanded clashobjects.clashobject.pathlink"[clashobjects.clashobject.pathlink.node]))

 

 

Regards,

Xiaoxin Sheng

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous,

 

I think Table.Combine function will suitable for your requirement. 

 

You can use 'query name'['Column Name'] to get specific column contents as list, then use this as parameter to in above function.

 

Sample:

Custom= Table.Combine(#'Query name'['Column Name'])

 

Reference:

Table.Combine

Operators

 

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Thank you @Anonymous.

 

I was able to add a new column using the Table.Combin function but I am getting an error. And the Advanced Editor is showing anything but the function I used.

 

See the last lines of the Advanced Editor below, if it helps to understand what I am not able to make it work.

 

The function I added was

Table.Combine([clashobjects.clashobject.pathlink.node])

 

Thank you for your help.

J

 

 

 

----------------------------

 

clashresult = clashresults{0}[clashresult],
#"Changed Type3" = Table.TransformColumnTypes(clashresult,{{"gridlocation", type text}, {"Attribute:name", type text}, {"Attribute:guid", type text}, {"Attribute:distance", type number}}),
#"Expanded clashobjects" = Table.ExpandTableColumn(#"Changed Type3", "clashobjects", {"clashobject"}, {"clashobjects.clashobject"}),
#"Expanded clashobjects.clashobject" = Table.ExpandTableColumn(#"Expanded clashobjects", "clashobjects.clashobject", {"objectattribute", "layer", "pathlink"}, {"clashobjects.clashobject.objectattribute", "clashobjects.clashobject.layer", "clashobjects.clashobject.pathlink"}),
#"Expanded clashobjects.clashobject.pathlink" = Table.ExpandTableColumn(#"Expanded clashobjects.clashobject", "clashobjects.clashobject.pathlink", {"node"}, {"clashobjects.clashobject.pathlink.node"})
in
#"Expanded clashobjects.clashobject.pathlink"

 

Error.png

Anonymous
Not applicable

Hi @Anonymous,

 

Nope, this function only works for list of table, when you use it in add custom column function(it contains 'each' Iterator), [Column Name] only means one item of list.

 

Please use #'previous steps'['column name'] to instead.

 

Sample:

 

Custom Column = Table.AddColumn(#"Added Custom", "Custom.1", each Table.Combine(#"Expanded clashobjects.clashobject.pathlink"[clashobjects.clashobject.pathlink.node]))

 

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.