Step-by-step guide for using the Power BI connector
Install the connector
Open the Power BI connector
Why don't I see Speckle as a data source in Power BI?
Load from Speckle
Import 3D Visual
Documents/Power BI Desktop/Custom Visuals
.Speckle 3D Visual.pbiviz
and Open.Visualize a model
Where do I find the 3D visual?
Where's the Model URL in the new Power BI connector?
Why do I get an 'Access to the resource is forbidden' error?
Why do I get a 'Permission denied' error?
Why do I get an 'Unable to connect remote server' error?
Can I load and visualize private projects with the Power BI connector?
Why doesn't my report update after a new version is published?
How do I visualize multiple models in Power BI?
How do I control the visibility of unselected elements in the 3D visual?
How do I hide the Speckle logo from the 3D visual?
Why can I view a model in Speckle but can't load it in Power BI?
Speckle
namespace to make working with Speckle data in Power BI more efficient and user-friendly.
Speckle.Objects.Properties
inputRecord
. Optionally, you can provide filterKeys
to extract only specific properties.
Speckle.Objects.CompositeStructure
Use this function to extract the composite structure of an object, such as a Wall, Floor, or Roof. This is especially useful for understanding layered compositions in your models.
Note: Currently only supported for Revit and Archicad models.
outputAsList
to true
to return the composite structure as a list—useful for expanding each layer into its own row.Speckle.Objects.MaterialQuantities
Quickly access material quantities of an object—ideal for use in Power BI’s “Add Column” transformation flow, as it operates on individual records.
outputAsList
to true
to return quantities as a list, which is helpful for row expansion.Speckle.Models.Federate
Previously, you could federate models by supplying a federated model URL. Now, you can manually federate already-loaded models in Power BI using this function.
Tip: This function allows you to federate models from different Speckle projects.
excludeData = true
to federate only the metadata necessary for 3D visuals (e.g., Version Object ID, Object IDs) without pulling in all the data.Speckle.Utils.ExpandRecord
This function expands a record column into separate columns for each field. It’s especially useful in combination with the Properties
helper.
columnName
) into individual columns in the table.
FieldNames
to limit the expanded fields.UseCombinedNames = true
to prefix column names with the record column name (e.g., Properties.Length
).