How to link hierarchy geometry in power bi

Help
,
1

Hi!

Within Power BI I try to link the information of the selection tree (Navisworks) to the geometrical objects.

Although it is possible to publish this information to power bi (include full hierarchy, great!), I cannot find the match between the ‘Speckle.Core.Models.Collection’ (Hierarchy) and the ‘Objects.Core.Models.GeometryNode’ (Geometrical objects). Also I’m wondering if there is a parent/child relation (or something like that) within the hierarchy.

Any suggestion?

Thanks,
Douwe

2

In 2.20 we added the facility that all data from First Object to the Geometry would be aggregated to the Geometry node. This is usually what is needed for these nodes.

Are you using 2.20?

If you need data all the way to the start of the selection tree there is a recursive method - I’m travelling at the minute but can see if I can get this too you asap - let me know

3

Thanks for the reply! I’m using 2.20 and all the information about the geometrical objects, as you mention, is there. But I’m looking for information in the selection tree (file name), so this can be used for filtering the geometrical objects.

1 Like
4

Right. This is some powerquery magic then. Which I can help with when feet are back under a table.

5

Hopefully you can find a way :smiley:

1 Like
6

Do you have a sample file and some idea of what properties you want to assemble?

Because Navisworks is just collections and geometries, and many of the property names between nodes are the same, you perform various strategies to aggregate this data.

Rather than trying to offer a solution that works on a model I have, it would be helpful for both of us to work on real data to the ends you want to achieve.