Publishing & Loading
How to use Speckle for Power BI
Step-by-step guide for using the Power BI connector
Speckle’s connection to Power BI consists of two parts.
- The Power BI connector lets you easily load your model from Speckle into Power BI in a tabular format.
- The 3D Viewer Visual allows you to view and color your models in 3d.
Speckle currently supports versions: . The connector works on only.
Setup
1
Install the connector
Install your connector
2
Open the Power BI connector
- Select Get Data. 2. In the search box, enter Speckle. 3. Select Connect to Speckle and click Connect.
Loading a Model
1
Load from Speckle
- Copy Model URL from the web app.
- Paste it in the text field and select OK.
2
Import 3D Visual
- In the Visualizations pane, select the three dots (…), then select Import a visual from a file.
- Browse to
Documents/Power BI Desktop/Custom Visuals
. - Select
Speckle 3D Visual.pbiviz
and Open.
3
Visualize a model
- In the Visualizations pane, select Speckle 3D Visual
- Configure the visual:
- Drag Version Object ID column into the Version Object ID input -> required for viewing
- Drag Object IDs column into the Object IDs input -> required for interactivity
- Drag any column into Tooltip input -> for tooltip
- Drag any column into Color by input -> for coloring model
- Wait for your model to load in the viewer