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)

Any further idea of how to resolve this? somehow still not working, I’ve been trying different ways but no luck unfortunately

Hey @FB_ENCODE,

Looks like I missed this! What you sent me are the Speckle connector and 3D visual files. I was actually looking for your Power BI report with the .pbix extension.

Thanks!

1 Like

Oh! my bad :slight_smile:

Here is the link to the .pbix extension:

Thanks!

@FB_ENCODE I just opened your pbix file and colors etc. seems to be in place and it’s interactive. Can you elaborate on what the problem is?

The issue is when using the data from the two tables highlighted in the screenshot; you can discard REF and SOURCE tables.

GetModelObjects has a GraphQL query which filters out only certain parts on the overall model (75 objects). The filtering is not getting visualised in the viewer when replacing it’s inputs (see posts above).

Hope it helps clarifying.

It seems like you haven’t created a relationship between the two queries.


After setting this relationship, everything seems to work.

2 Likes