That is a great news !
Hi Alan,
Did you posted something?
Regards
1 Like
Hi @gjordanp,
sorry I didn’t get to do this, got to pause this in preparation our new 2.7 release of our connectors, but I’ll do so soon enough!
Only thing I’m trying to get working before publishing the code is getting highlight to work with model selections and vice-versa. I’m pretty close, but if anybody has any experience in PowerBI Custom Visuals and is willing to give a hand, I’ll be happy to schedule a quick call. 
I’m sure my problems are coming from my own ignorance, rather than PowerBI 
Anyway, sorry for the delay! I’ll update you all here once we have something that minimally works 
9 Likes
Hello,
in case it helps I just released a github repository with a custom visual to upload Rhino3D models to Power BI: GitHub - diego-apellaniz/PowerBI3D: Custom Visual for Power BI to visualize 3D models and connect them to your data
Thanks for your great work!
7 Likes
Good afternoon, I was going through the tread and have not seen that the Revit → Power-BI 3D viewer in Power-BI was released, I am seeing the 3D viewer Edge or Chrome. Will there me a 3D viewer for Power Bi
@AlanRynne
Regards
4 Likes
Is there any news on this? Thanks.
2 Likes
Hey everyone! 
after a long wait… we’ve finally managed to get some things going regarding Speckle + PowerBI Visuals!
We present you the Speckle PowerBI 3D Viewer:
This is still very early stages and has very basic functionality, but you can go get it from our repo releases page:
I’m wrapping up the docs for the visual (including installation guide and usage), and should be available throughout the day on the PowerBI section of our Docs
Power BI | Speckle Docs (but you can go read the not-yet proof-read version here if you’re in a rush!
In order to use the viewer you will have to update your
Speckle Data Connectorto version 0.0.10 or above. You can find all released versions in the Data connector repo releases page:
Releases · specklesystems/speckle-powerbi · GitHub
Kudos to @Reynold_Chan and @gokermu for battling this one with me! 
We’re releasing this to the community in super early stages to give you a chance to speak up about what’s missing, what works and what doesn’t. So don’t hold back!
What’s next?
We’re still using the old 3D Viewer, but as soon as our new viewer implementation is stable we’ll switch to that one. This will enable:
- 2 way selection/highlight (currently it’s 1-way due to some of our own API limitations)
- Better loading/unloading logic for individual objects
- Shadows!
- Loading the objects from a record (instead of fetching them from the server every time)
- … and possibly more!
As for the Data Connector, it has also been updated and we’re keen to hear about your thoughts on that, and what would a “better structure of data” look like. Is the current table useful? If not, what do you think is missing?
13 Likes
Awesome! The gif people have been waiting for! 
I tried to have a quick look (replaced the old mez file with the new one from v0.0.10), but I got an error when trying to read a stream (my private stream on Arup server). The error is also mentioned and fixed here: Power BI - We cannot apply field access to the type Null
Can I do something on my end to fix it?
and some extra characters to hit the minimum
2 Likes
+1
I’m getting the same.
1 Like
Now the PowerBI Data Connector (release v0.0.11) works @AlanRynne ! 
But the visual is not loading the objects.
Here’s a snapshot, showing the table and the values in the Stream Url and Object ID.
The Stream is set to public and is just containing the Basic Sample Project.
1 Like
Finally got it working - sort of. 
I think that the issue had to do with the fact I was trying to visualize objects from another server than the ones that speckle is hosting.
At least I found this under the About menu for the visual.
Would you be able to make it working with non-speckle-deployed servers?
2 Likes
Hi @martinromby!
I missed your reply during the weekend 
There is a limitation on PowerBI’s Custom Visual API, since version 4.6 it forces devs to implement a privileges section that I may have implemented in a very strict way.
I just pushed a new version that should allow for connecting to any speckle server, but I’m not sure if our security expert @iainsproat would throw a 
at my face for doing so . Since we’re currently testing this, I think it’s fine, but this decision may be revised
3 Likes
Cheers @AlanRynne !
I can confirm that it works on non-speckle deployed servers.
Hopefully @iainsproat won’t be that cruel 
2 Likes
Great, thanks Alan! It works on my end as well.
Would be good if there is a sustainable way to allow connecting with any Speckle server so more people can use it (@AlanRynne another advantage is that you don’t have to wear a hardhat while sitting behind your laptop 
)
2 Likes
@martinromby @JdB, nice to know you got it rolling!
To you and whoever else gives this a go: I’m sure there’s a lot you’d be missing in the current visual so don’t hesitate to make a list and send it our way!
1 Like
Hi Alan, I gave the viewer a test this afternoon and it’s really positive to see that it’s able to display the geometry alongside the data now (look forward to viewer update too). I’m not sure if this is an isolated case but when I’m pulling the data from the stream (it eventually did it but after 3 minutes). The same issue existed when splitting the data column (took another 3 minutes to retrieve this). Eventually I was able to pull together a demo. It’s really exciting!
One request I’d make would be to enable the extraction of IFC PropertySets from IFC Files. I was able to separate by IFC Entities (Speckle Types) but the ability to filter by additional Property Sets would be great.
1 Like
Hey!
The viewer and connector works very nicely and its super smooth, really nice work!
The gradient mapping for numerical values seems to bug out when a null value is within them. Really excited to get the new viewer in there with 2 way highlighting. Will we be able to get comments that are set in speckle to show up in the 3d viewer in powerBi the comment system really changed how we send reports internally, to couple that with highlighting and graph functionallity would be amazing.
Being able to “pre slice” views so that they are set up similar to floor plans would also be something really good, ofcouse this can be done with tagging geometry with floor levels or checking Z values and just filtering that out, but to ease the use of setting the PowerBI up that functionallity would be great.
5 Likes
As an aside: I’d really like to hear more on that - I might want to jump on a call with you! We’ve recently revamped the viewer (a lot!), and there’s some incompatibilities between old filters and new. Anything you can share with us on the comments as reports front would help (you can DM me in private).
As for comments support inside powerBI, it’s going to be an exercise for @AlanRynne, myself and @alex to enable that!
We were thinking of that already, and @alex is trying right now to hack some nice section planes to go with it. Would it be useful in the viewer frontend as well?
You can already isolate specific levels, if your model comes from revit and is clean:
See this comment for example as well:
4 Likes