September 10, 2024
July 13, 2023
Tutorials

Viewing Revit Models in Power BI

In this tutorial, we will show you how to view your Revit models in Power BI using Speckle. Follow along as we send the data from Revit, receive it in Power BI and visualize it using 3D Viewer Visual. Let’s get started!

Mücahit Bilal Göker
Product Owner
Contents

Video Tutorial

Prerequisites


In this tutorial, we assume you have:

Step 1: Send from Revit

Let’s start with sending data from Revit.

  1. Open the Speckle Connector in Revit
  2. Choose an existing project or create a new one.
  3. Click on “Send” to send everything to Speckleverse.

Step 2: Receive Data in Power BI

Receiving the data you sent from Revit in Power BI is pretty simple.

  1. Copy the URL of the sent model from the Speckle web application.
  2. Open Power BI and navigate to "Get Data."
  3. Search for "Speckle" in the Data dialog.
  4. Choose the Speckle connector (not the one with [Structured] tag) and click "Connect."
  5. Paste the copied URL into the connector's prompt and click "OK."
  6. Load the received data into Power BI's query editor.

Step 3: View Model in 3D

Now we have received data from Speckle, let’s view it in 3D.

  1. Add a Speckle 3D Viewer Visual to your Power BI dashboard.
  2. With the Speckle 3D Viewer Visual added, you can now configure the input fields to display your Speckle data.
  3. Drag the "Stream URL" column from your data into the "Stream URL" input field.
  4. Drag the "Commit Object ID" column from your data into the "Commit Object ID" input field.
  5. Drag the "Object ID" column from your data into the "Object ID" input field.
  6. Once all inputs are added, 3D Viewer Visual will load the objects into the scene.

Conclusion

Congratulations! By following these three simple steps, you have successfully integrated your Revit data into Power BI and use it for data visualization and reporting. Send your Revit data to Speckle, receive it in Power BI, and visualize the model in 3D using Speckle's 3D Viewer Visual.

Try this tutorial, let us know what you think!

Subscribe to Speckle News

Stay updated on the amazing tools coming from the talented Speckle community.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Author
Mücahit Bilal Göker
Product Owner

Hi, my name is Mucahit. I am always curious about new technologies and innovations, always up-to-date.

Visit LinkedIn