Issue with Shared Parameters in Power BI from Revit

Help
, ,
1

Hi everyone!

I’m struggling with extracting a shared parameter from a Revit structural model into Power BI and need some guidance. Here’s my workflow and where I’m stuck:

  1. Revit Model & Shared Parameter:
  • I have a structural model in Revit with a shared parameter named “PM_Semana-de-obra”.
  • When I send the model to Speckle, I can see the shared parameter in the Speckle 3D web viewer.
  1. Problem in Power BI:
  • When importing the Speckle data into Power BI, I am unable to see or extract the shared parameter.
  • I have tried different methods and followed the available videos on extracting parameters but haven’t succeeded.
  1. Alternative Approach:
  • Since I couldn’t extract the shared parameter via Speckle, I exported a Revit schedule (which includes the shared parameter) to Excel.
  • Then, I imported the Excel data into Power BI to relate it to the Speckle model data.
  1. New Problem – Data Relationship:
  • The schedule I exported contains only columns, while my Speckle model includes columns, beams, floors, and walls.
  • I am struggling to relate the data between the Excel schedule and the Speckle model inside Power BI.
  • I watched a video on doing this with rooms, but I couldn’t apply the same method to my case.

What I Need Help With:

  • Option 1: How can I make Power BI recognize and extract my shared parameter directly from Speckle?
  • Option 2: If that is not possible, how can I properly relate the Excel schedule data with the Speckle model in Power BI?

Any advice or guidance would be greatly appreciated!

Here is the link to the model: freire 2610-est - Freire 2610 | Speckle
Here is the link to the schedule: freire 2610-tablas - Freire 2610 | Speckle

2

image
image1920×462 61.7 KB

As you see in my screenshot of your model, on the right is the user-friendly view of the parameters, and on the left is the dev-mode view, which shows that the “BRA_PM_Semana-de-Obra” parameter is stored in Revit with a GUID “6ead3eca-4a31-49f7-9b7c-f5e6d2cb921a” .

You have watched some of our videos, but you are in luck; we have a specific tutorial just for you:

The link above goes directly to the relevant powerquery command that will resolve all those GUID-bound parameters to human readable. Speckle.Revit.Parameters.ToNameValueRecord.

More good news for you is that the Next Gen v3 connectors are being built with Data extraction workflows in mind. If you download your Revit connector from Manager again, the latest version (2.21.3 at the time of writing) has the Beta connectors distributed alongside the current set. Try it out and let us know!

1 Like