I’m new speckle user, and I have several 3d models trying to get a federated model in power Bi
I combined the data of each discipline to get a view for each. The issue is the viewer shows missing elements and behaves differently each time I open the file, yesterday I combined the data of one model published in parts in speckle due the size I guess, it was showing normal, this morning is missing most of the 3d elements! Am I missing something here?
Hi @Salimabd,
Welcome to Speckle!
Could you please let us know which version of the PowerBI Connector you are using?
Additionally,
- could you tell us the model size
- share a screenshot of the model in the Speckle Web Viewer along with a comparison screenshot highlighting the missing elements? It’s a bit difficult to understand the issue without seeing it.
FYI - it is possible to federate models across projects, but unless they are co-located and relatively small, I wouldn’t recommend it. It is better to federate everything first in Revit and send it to Speckle as one model and then send that to PowerBI.
1 Like
Hi Nikos, while I’m looking for the connector version I noticed that I used the method copy/past in power bi desktop folder and I have it installed from manager too which is the latest update, not sure which one I’m using 
For the model size depends some of them were light and I published them to speckle some of them were partially published one of them in 6 batches, but I published them one by one.
sorry I can’t share the project screen shot as of now
Please let me know after combining in speckle how to push that specific view to power bi and show it in the visual ?
Thanks
Hey @Salimabd,
If you right click on the blue cube and then click About you can check the Speckle version.
Based on what you’re saying, it sounds like your model is quite large. I apologize if I wasn’t clear earlier—what I meant was that you need to first federate everything in Revit and then send it as a single model to Speckle. After that, you can send it to PowerBI. However, with very large models, this can be challenging because you’ll need to send it in batches.
Your approach of appending multiple queries is currently the only way to visualize everything in PowerBI. With the current version there are some known bugs when applying the slicer and conditional formatting, which are our top priority, and we’re actively working on them.
For now I recommend trying the 2.18.0 version and following this tutorial if you haven’t seen it already.
the 2.18 files are attached bellow.
powerbiSpeckleVisual.2.18.0.pbiviz (1.7 MB)
Speckle.mez (43.0 KB) (save this under \Documents\Power BI Desktop\Custom Connectors)
You might also find this post from Jonathon helpful:
2 Likes
I noticed that using Navisworks connector and getting the data into power Bi is not the same as using Revit connector. I did a comparison pulling the data from the model sent from Navisworks has only 50 rows while the data from Revit has thousands