Hi guys,
I’m using the newest Power BI visual and connector with Revit 2024 and working on Autodesk’s new Snowdon Tower Project Sample for a couple of weeks.
I have a little issue on my side.
I can’t get Type and Family information for “Objects.Other.Revit.RevitInstance” elements. This type of element seems doesn’t have relationship connections with Types and Families but they have with Categories. I know we have relationship Category >> Family >> Type in Revit, but it seems I don’t have it now in Speckle. Maybe this is related to new updates. When I go to “Transform data” in Power BI I have empty cells for “Objects.Other.Revit.RevitInstance” elements. Please see the video and image. I don’t remember I have this issue before. Any help is much appreciated.
Sorry for the delay @salpbes, we’ve been busy getting lots of things done.
What you are seeing is a consequence of the development of Revit Instance support in Speckle. The Instance and the Definition do carry different data on each. There is no way to carry instance data on the definition object. What we have chosen to do, is keep the Definition data where is sourced rather than propagate to the Instance.
That being said, to get the data you want is a straightforward Self Join.
I’ll break that down into steps. (I will remove columns for brevity per step)
The source stream - No magic here, just the base query to a URL.
Without doing any other transforms, use the Speckle Source as a Reference
What that allows is for a single Speckle Query to be used for all the subsequent steps
Name that new query Instance Data and duplicate the data column
Expand the data - copy to reveal first the definition and then again to expose the referenceId
A Left Outer Join will keep all the rows from Instance Data and add the Definition row that it points to (If I hadn’t omitted blank rows, an Inner Only Join would retain only those matches that can be made)
This might make sense to do so. Data from Definition to Instance could be similar to the need to aggregate data from Collection to Element, as we were discussing viz. Navisworks