Model versions in Power BI

[D.S_Bosma]

Hello,

I’m new to Speckle and have a question about model versions in Power BI. I am wondering if it is possible to have multiple modelversions and data within 1 query, so I can create a quantity trendline based on the model versions (date) + Show the quantity difference between the versions. If possible; without creating a new branch every time a new version is released, but by refreshing the data-set.

Below the steps I have taken;

1. Create a model ‘basic construction

2. Upload version 1 of the model (.ifc) to the project (drag and drop in browser)
   

   

3. Load de data into Power BI and visualize volume and length
   

   

4. Update the previous model, by uploading version 2 of the modelfile (.ifc) to the project (drag and drop in browser)
   

   
   
   
   

5. Refreshed power bi report; the Id is updated, as is the geometry and dimensions.
   

   

So by refreshing the data; only the latest model will be shown.

Does anyone have an idea?

Thanks in advance!
Bosma

[jonathon]

The short answer is that you can set your Speckle data source URL to the model, and then the latest model will always be shown; this is the expected behaviour, as you have suggested.

There are a couple of paths to getting the outcome you are describing, depending on how complicated you want it to be.

1. Simple Before and After comparison
   You can add two Speckle data sources as separate queries but set the version URL as the source.

You can UNION the two queries with a date field added.

2. For a more dynamic workbook, you can leverage the Speckle API to make a query of all versions. It will require a more involved setup. Fortunately, one of our PowerBI heroes, @AlanRynne, presented something to use as the basis of this at the last SpeckleCon: PowerQuery(QL) for AEC Data Analysis

Power Query for AEC Data Analysis

[D.S_Bosma]

Hi Jonathon,

Thank you for the quick reply and suggestion!
I will look into the Speckle API, the video is very helpfull.

Regards,
Douwe