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
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
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
In order to use the viewer you will have to update your Speckle Data Connector to version 0.0.10 or above. You can find all released versions in the Data connector repo releases page: Releases · specklesystems/speckle-powerbi · GitHub
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?
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?
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
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 )
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!
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.
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.
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:
In order to use the viewer you will have to update your 
at my face for doing so 
)
, thanks for the enthusiasm!