Partial Geometry Display - Power Query

Hello community,

I’ve been testing some workflow in PowerBI using Power Queries to filter out large models with only specific elements; it seems to all work as expected on the data side, but the 3D viewer on PowerBI is only showing one element (the first) rather then all the filtered ones.

Drilling through the object id data show the objects one by one correctly instead. A couple of screenshots are attached showing the data table and corresponding dashboard.

Any idea what it could be?

Cheers!


Hey @FB_ENCODE,

The 3D Visual needs the Version Object ID field to visualize all(or a part) the elements - in your second screenshot is missing, also is missing from your table. You can include Version Object IDs in your table as a column or create a relationship with the Original Query table using the IDs.

This is without Version Object ID

This is with Version Object ID

This is with Version Objects ID and filtered rows

I hope this is clear, let me know if you need anything else.

Thank you @Nikos for the prompt response :-).

That’s all clear and always worked for me, what I meant is that i’m using a GraphQL query in PowerBI and fetching only some parts of the overall model. Where do i retrieve the VersionID of each brep in the model?

Screenshot attached with the GraphQL query.

Thanks!

Hey @FB_ENCODE ,

From your screenshot, i can see the “objectId” you are fetching is a root object id so you can use that as the version object id.

1 Like

thank you @gokermu :-).

I extracted the root objectID as a query and plugged it as VersionObjectID, all good till here, the global model is showing correctly (screen 1)

When i plug the column of filtered ids (and create the relationship manually, if I don’t doesn’t do it automatically) though the viewer gets stuck loading (screen 2).

Am I missing something somewhere?

Thanks!

Object IDs expect the id’s of individual objects. If your “id” is that it should work. Just make sure you connect it to “Tooltip Data” column too. I think that’s needed for filtering and interactivity with other visuals.

VersionObjectID → single value root model ID
ID → individual objects ids (beams elements in the model)

No luck still somehow, gets stuck loading without applying the filter.

Can you share the pbix file with us? @oguzhan any idea why it might be happening?

1 Like

Of course, thank you very much.

Speckle Power BI 3D Visual.pbiviz (1.3 MB)

Speckle.pqx (35.7 KB)