Customising the data source import from Revit - Speckle - Power BI

Help
1

  • Objective: I want to import multiple models with selective parameters from selected categories across multiple streams into Power BI to do comparison/benchmark checks

  • Issue: PowerBI is running slow when importing the entire Stream URL content. Is there a way to only bring categories and selected parameters to reduce the lag. Is this possible by converting the Graph QL query into Power BI M language?

Thanks,
Matt

1 Like
2

Hey @BIM_Wash ,

There are two ways you can do it.

Firstly, you can send only the categories you want to receive in Power BI from Revit.

Secondly, there is a new function called “Speckle - Get Stream by URL [Structured] (Beta)” in the Get Data dialog. This option allows for much faster interactions with your Speckle data, as it no longer requires you to pull every single object as a flat list. However, the downside to this approach is that you will no longer get the data with the expected columns to connect it directly to the Speckle Power BI Visual.

image

:warning:WARNING
This feature is experimental and may change in future releases.

1 Like
3

In addition to @gokermu’s answer:

You can also directly do graphql API calls to speckle with the data connector.

This is not exposed as a “data source” but can be accessed directly from the Query Editor in PowerBI, just like any other PowerQuery function.

Its called Speckle.API.Fetch and takes in the graphql query as text and a record for the query variables.

That being said, this gives you total control but also forces you to deal with creating the flat table with the correct columns. Just like the structured option @gokermu mentioned.

Hope that helps!

1 Like
4

thanks @gokermu and @AlanRynne for tyour prompt responses.

I have only sent the revit categories I want to see in the stream. I was hoping to specify just the parameters I am interested in, rather than all of them.

I will give the second method @gokermu mentioned and look at the graphql approach.

Also. Is it possible to bring in Revit project parameters such as project name and project id or is it just restricted to model-based elements and associated parameters?

Thanks,
Matt

5

Ignore my last question… I found the relevant speckle_type for the project info.

Objects.Organization.ModelInfo:Objects.Organization.BIMModelInfo:Objects.BuiltElements.Revit.ProjectInfo

Thanks,
Matt

1 Like