Power BI - Offline Speckle Connector

Hi Speckle Community,

I am at the moment checking out powerbi with the “offline speckle connector”.

i am wondering is the command Speckle.Revit.Parameters.ToNameValueRecord not existing as soon as i work with an offline Speckle Project? For some reason it does not show up. If its not existing, is there another way to replace this function?

Hope to hear from you,
Best, Anna

1 Like

Hi @aheimrath,

I’m glad to hear you’re exploring the cutting edge of the Power BI connector! I wanted to provide you with some updates:

Due to row size restrictions in Power BI visuals, we had to develop a new approach for the next-gen Power BI connector. While @dogukan was rewriting it, some functions may have been removed during the cleanup process.

The new version is now available, and from my testing, it handles large models quite well and visualizes private models too. Please uninstall the previous version of the Power BI connector that you have and install the Next-Gen Power BI connector from this link.

I believe the connector includes the Speckle.Revit.Parameters.ToNameValueRecord method you mentioned (I don’t have access to power bi right now), but please let me know if it’s missing. We can add it quickly.

Best regards,

3 Likes

Hi @gokermu @dogukan

thank you so much for the quick response. currently i am using already the beta.58 version for power bi and this one does not include the “Speckle.Revit.Parameters.ToNameValueRecord” method unfortunately.

Is it possible to add it - it is desperetly needed :pray:

1 Like

@dogukan can you add mentioned function back and cut a new release please?

4 Likes

Hi @aheimrath ,

Good news, latest Power BI release includes “Speckle.Revit.Parameters.ToNameValueRecord” function. Download Next-Gen Power BI connector and give it a try!

4 Likes

Hi Bilal, i am already happily using it since the first release :slight_smile: It works perfectly fine. I only have a problem with slightly bigger projects. Power BI keeps crashing and gives me this WebView2 error … any ideas if this is speckle or a power bi issue?

Hey @aheimrath, sounds like… somewhere in between. This is @oguzhan’s favourite pastime (joking). Would you be able to share the model with us, privately? This is the only way we could optimise and figure out where the problem is.

This is a memory problem on browser with huge models. There are potential solutions

  • Shrink the data more
  • Advertise send filters more to users
  • Enable parameter filtering

Other than these, I am not so optimistic to solve the memory pressure on an powerbi-visual API that out of our control.

hi @dimitrie @oguzhan
Sure i can follow your advise and invstigate a bit.
Do you want to have a look in the model anyway? I can share it with you

Ive enabled access to a shared drive with you Anna

There is still room to improve on our side to optimize data size more on send, but we also expect users to send only relevant data when it comes to huge models for their sake.

We will investigate the model once we have it! Thanks for reporting

@oguzhan And what are the current restrictions on the size of models?

According to our tests, we managed to load ~1GB of data to our visual. Currently we are working on an optimization to push this limit more, but there will always be a limitation since the visuals in powerbi are not designed to deal with big data.

1 Like

@oguzhan
Is 1 GB a native file (ArchiCAD, revit, Sketchup)?
Or is 1GB of data of a BI file?
Or is 1GB of data of a speckle file somewhere on the server?

It is data in the speckle server since we run that data in powerbi visual

How can a user see this information about the size of the data? Is it available somewhere?

It is not user-facing information, but you can download and check it if your browser allows you to do it with big model. You can use the endpoint → https://{serverUrl}/objects/{projectId}/{rootObjectId} as example https://latest.speckle.systems/objects/126cd4b7bb/a7bacfe1c1d629d34c1d5306016d9122

The comparison of the data sizes between host applications and speckle is unknown. We can’t say 10MB of Revit data will be extracted as 10MB of Speckle data, it depends what/how you send your data.

2 Likes

https://app.speckle.systems/projects/b5c38a07cb/models/b3551328c1
Can you use my example to show how it works?

Your model can be explored - the first branch under the model name is the version
Screenshot 2025-03-13 153243

Inspecting this in Selection Info shows the ID

So with your project ID
https://app.speckle.systems/objects/b5c38a07cb/e3e7208f4c25825c702af3200a5596b7

2 Likes