Maybe similar challenge (or maybe not) The properties I see in the viewer look just fine - but how to dig down through the ‘record’ to actually find them in PowerBI
The video that @jonathon shared showcases different ways to access Revit parameters in Power BI. Currently, we sent Revit parameters by their GUIDs from Revit because that’s the only safe way to make sure we don’t have duplicate names.
To answer your question, yes it is possible to access custom parameters in Power BI. We recently implemented a function in Power Query called ToNameValueRecord (we cover this in the above video) that makes interacting with Revit parameters much easier.
Please take a look and let us know if you have any issues.
Hi @gokermu, thanks for getting back to me. I have used the ToNameValueRecord in the past to extract parameters from modelled elements. The challenge I seem to be having is finding the custom project information parameters that I am sending via the “project information” filter.
I can see some of my project information parameters are hear, but not all of them. The highlighted ones don’t appear to have been streamed.
I just looked into it and looks like you found a missing feature. We’ll add support for custom parameters in Project Information in coming releases. Thanks for reporting this😊.
has there been a change to how Speckle.Revit.Parameters.ToNameValueRecord behaves since this was posted - following the video howto above I am getting both the parameter name AND speckle alias in the new record:
What you see in square brackets is the Internal API name of the parameter. Parameter names in Revit are not unique, so we had to do it this way. You can get rid of what’s in square brackets easily.
