I am trying to analyse some model data in powerBi… I cant seem to be able to get my familiy names and types for loadable families like windows or doors… what am I doing wrong ?
in the speckle viewer, i can see the data under “definition”… but in power BI, it isnt similar - the Record called “definition” doesnt contain the same data:
The referenceId property of the RevitInstance data.definition` is the speckleId of the definition object.
In the viewer, we are merging this data for ease of navigation and inspection of the scene. The powerbi data connector, however, gives you a flat list of all the objects from that model version.
I could go into the nature of how Speckle stores immutable object version data, but for now, I could refer you to this answer I gave a little while ago:
Power Bilal has a function he has written that may help shortcut this for you. It will depend on you specific needs which approach is best
