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.
This feature is experimental and may change in future releases.
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.
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!
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?
Ignore my last question… I found the relevant speckle_type for the project info.