Revit creates unique keys to enable this linking. This will take a few moments to load in the data from MS Excel.īefore we start working on the visualisations, we need to create some relationships between the type and instance properties. In this example we will select the following tables:Ĭlick the Load button. Power BI will then connect to the data and present the Navigator. In this case we will connect to our Microsoft Excel workbook. The first step is to connect to a data source. In this tutorial I am using the desktop version. Once Microsoft Power BI is running the interface should look like the image below. In the image below you can see the worksheet for the floor instance.īelow is the table representing the floor types Additionally, the tables are differentiated by instance and type. Just as a quick recap, when exporting Revit model data via ODBC, Revit creates a data table for each model category. Hope this helps people to start their Revit learning! Feel free to comment on the video series and make suggestions! You can find a link to the datasets here:

The course is project based and builds on skills learnt on previous tutorials to build a full structure from a blank template.

I am continuing to build the course and hope to cover all the essentials skills to work with Revit 2021 using Steel, In-Situ Concrete & Precast Concrete.

Currently I have the first module created (40 mins) Additionally, I have created a website that hosts the required datasets that are needed for the online course. I have started to create a course that is FREE and hosted on my YouTube channel. However, there are many of you that are possibly still using 2D CAD applications that would like to move into Revit for project delivery, or those that may want to revisit the essential skills required to use Revit. Some of you may have been Furloughed or unable to work during the current COVID-19 crisis and I am continuing to create tips and tricks, tutorials and videos that are suitable for intermediate/advanced users of Revit.

Revit for beginners 2021