Creating a Power BI dashboard with a Karamba3D/Speckle Structural Model

Hi Speckle Community,

I attended the SpeckleCon last week and was really inspired by the Karamba3D and Speckle Power BI workshop. This week I tried combining those two to see if I can create a dashboard to get inside about my Karamba models.

I started by just trying to attach the utilization values to the elements, like we did in the workshop with Mass and Volumes. The values are visible in the 3D viewer on Speckle, but when I try to access them in Power BI it seems Power BI is not loading that part of the data in there. It seems it’s not showing Element1D objects (or 2D and 3D, tried them as well). Only some geometry objects and properties like cross sections and materials. Is there anything I’m missing or is this an undeveloped part of the Power BI connector? I tried to show it in the screenshots and this is the model I’m using:
rhdhv/yannick_out - BESO Tower | Speckle



Hey @Yannick,

The reason this is happening is that the parent element of that object does not have an application ID, and our Power BI connector does not display objects with a null application ID. Could you please check if you can set the application ID for that collection in Grasshopper?

Thanks!

1 Like

Hi Bilal,

Thanks for replying! Maybe I don’t really understand it, but it looks like the elements I’m missing in my Power BI data do have an applicationId

Elements themselves do have the applicationId but it’s parent DataChunk does not. When you select an element in the viewer, element is selected, not it’s parent. You can see the full structure of your model from the advanced mode in the Scene Explorer.

image

image

Ah okay I see. I used both the Karamba 3D WIP component to convert a Karamba model to a Speckle structural model as just the Speckle components to create a Speckle structural model. But with both workflows there’s not an input to create these applicationId’s. Is there a way to add/change them in Ghrasshopper? Also the displayvalue would be nice if that can be changed. The default displayvalue for an Element1D is a line, but it would be nice to have a mesh of the cross section (like the Karamba WIP component has)?

If Karamba nodes accept additional inputs, you can override both applicationId and displayValue inputs. You can check if that’s possible by zooming into the node inputs and check if “+” icon pops up.

@mtam if the Karamba team can offer any insight, your contribution is welcomed!

I think it is not something that has to do with the Karamba (WIP) component. When I create a Speckle Structural model with the Speckle components in Grasshopper, the same thing happens. Still there’s no applicationID.
When I try to add an additional input to overwrite the displayValue with the Element1D component it shows an error “1. Solution exception:Failed to set value for Element1D.displayValue”

This model is uploaded here: powerbi - TEST | Speckle


@Yannick Element1D object only accepts baseLine as it’s displayValue. This seems to be restricted in the object schema. But you can still override the applicationID.

For the display value issue, you can create a new speckle object and put the displayValue there as a workaround.