3D Models Visuals in Power BI

Hi guys, I just wanted to share a dashboard design that I created from Speckle PowerBI Visual. So far it seems very good. But it takes too much time to load elements. Overall it is working and thanks a million for this visual. Great work.





7 Likes

Amazing dashboard!!!
Is the Revit model you used free? Can it be downloaded from somewhere? Thanks!!!

2 Likes

Hi there, thanks @riverlander. The file I used is from Autodesk. They used it in their training.
Here is the website Learning Courses | Autodesk
But I don’t it is free or not for commercial usage.

2 Likes

Thanks so much for sharing @salpbes , we often struggle to see how Speckle is used in the wild :slight_smile:
We’ll definitely take your feedback into consideration when working on more stable versions of the connector :hugs:

5 Likes

Thank you very much! @salpbes

4 Likes

Thank you, guys. I am more than happy to help. Eagerly waiting for the new versions. I think with Power BI integrations there are endless possibilities for Speckle. Great work so far. If you need anything please let me know.

4 Likes

Hi guys any news on speckle Power BI?
Thanks in advance.

2 Likes

Hi all!

Just bumping this thread to let you know we’ve released a new version of the PowerBI visual that comes with some nice improvements and fixes:

Most of these have been added based on your feedback, so thank you very much for taking the time to test and come back to us :raised_hands:t3:

We hope you find these new features useful. Keep in mind that we’re still experimenting on how the visual and the data connector should interact and work, so do keep those requests and ideas coming to help us shape an awesome user experience :slight_smile:

4 Likes

And here’s a sneak peek of what’s already coming on the next release :wink:

  • New ColorBy input used exclusively for applying color filters (Object data is now named Tooltip Data and is used for tooltips :point_down:t3:)
  • New custom tooltips, where even the prop name is customisable. This also allows to apply data to the tooltip that is not stored in Speckle

Connecting any of the 2 (ObjectData or ColorBy inputs) will result in highlighting being active.

2023-02-07 09.40.00
2023-02-07 09.40.44

7 Likes

How do I select the branch I like it to take the model from?
Its randomly taking model from branches that I don’t intend to use
image

1 Like

Alright, you can’t have spaces in your Branch name, just like python, use underscore.

Make sure you copy the URL from Chrome, as spaces are not “url safe” characters, they get swapped for %20 instead. If you just manually write the branch name in your url, this will work in chrome (as it n knows how to escape URLs) but won’t work in PowerBI (URL parsing logic is super basic in PowerQuery).

Notice the change in the space character done automatically by your browser:
Screenshot 2023-03-13 at 11.09.51
Screenshot 2023-03-13 at 11.09.57

So just to clarify, branches with spaces in the name are supported, but you need to have them properly encoded.

3 Likes

Hi

I somehow managed to have the images below kind of dashboard (thanks for the Speckle team).

I have tested two workflow (a&b).
I prefer to deal with the workflow-a because it is a simple workflow in this case.

Issue:
There is a problem with workflow-a:
when I selected each window type one by one, no objects are highlighted in the 3d viewer (please see image below Workflow-a).
If the initial GH model has only windows type, then the objects are highlighted in the 3d viewer.
Also selected objects are highlighted in the 3d viewer in the workflow-b.

Q1) Is there any limitation of model’s file size or number of objects to use this method?
Q2) In the b case, the objects are highlighted but other objects are completely invisible.
Is there any way to make the other objects visible as the sample image in the Speckle tutorial?

Workflow-a) GH->PowerBI

Workflow-b) GH->Rhino->Revit->PowerBI

*The both (a&b) cases have almost the same amount of objects as shown image below.

Hi @SungBok_Song!

Thanks for reporting this and giving us some info of your workflows!

I think I’d have to have a look at your data and report in order to figure out what’s going on there. But it could be some miss-configuration of the visual inputs (or their names).

As for your questions:

There is a hard limit of 30000 objects that is placed by PowerBI’s API. Any more than that at it would be possible to show “pages”, but we haven’t implemented pagination yet on our visual.
I suspect this won’t really allow you to see more than 30k objects at once, but rather see 30k at a given time, and choose which “page” to show.

Based on your screenshots, I’m guessing you’re using a Slicer? AFAIK, slicers will filter the amount of data that is passed to the visual, so the visual “no longer knows” about the rest of the building.

PowerBI visuals have no context of the report, they only know about the data that is connected.
I guess what you want is the highlight behaviour, which is done by selecting multiple items at once.

To achieve what you want I think you may need to do some grouping of values on your side (possibly in PowerQuery directly).

Anyhow, If you can share the report and speckle stream (or a minimal reproducible version of it) I’d be happy to check out what’s going on and hopefully give you some tips

Hi AlanRynne,

Thanks for the reply.

Yes, I used Slicer.
what is the way to make groups of value?

I am really new to use speckle.
Where can I share my report with speckle team?
Is it enough to submit PowerBI file?

Yep, just send me a message privately with the Stream URL and the PowerBI file :slightly_smiling_face:

For the groups, there are several ways of doing this, but the easies is to let a Matrix table group them for you.

Screenshot 2023-04-04 at 09.53.39

Just add multiple “Rows”
Screenshot 2023-04-04 at 09.53.42

And the table will have nested grouped values that can be expanded/collapsed

Screenshot 2023-04-04 at 09.53.47

If you select any of the parent items, all the items bellow it will be “selected” and this should give you the highlighted items with the rest of the building ghosted.

There are other ways of doing this by doing some data wrangling on PowerBI’s side… Anything more advance will require some PowerQuery skills (this is not Speckle specific, any data received in PowerBI usually requires of some massaging at least)

Hope this helps! And I look forward to receiving your report :wink:

2 Likes

7 posts were split to a new topic: Thanks for the PowerBI improvements - Example Implementation!