Visualize and use the data of your digital model with Revit and PowerBi
We are flooded with information. To navigate, what is useful must be filtered upstream, and despite all this data can be redundant and other times useless. It goes without saying that BIM tools only exponentially increase the available data related to a building or construction process.
Accessing and seeing all this data in a column of letters and numbers is not very evocative. This is why we are going to use the Business Intelligence tool to view them.
Why ? To inspire and quickly synthesize concepts in the blink of an eye. To explain and better communicate ideas. And finally, to analyze and make decisions.
In the tutorial that follows, there will be an example of visualization of the data extracted from Revit to PowerBI, and it will be mainly focused on the maintenance of the models.
In this example we will follow these steps:
- Step 1 : preparing and extracting data from Revit
- Step 2 : import of data to PowerBI
- Step 3 : selection of the types of graphics and some parameters
- Step 4 : publication on the web
- Step 5 : updating data
Here are the prerequisites to follow the tutorial:
- Autodesk Revit (here 2017.2)
- Dynamo (here 1.3)
- Microsoft PowerBi (you must have an account, there is also a 60 Day Trial version, otherwise you will not be able to share graphics)
In a Revit session, warnings accumulate and are listed in a list.html. All you have to do is click on the icon in Management to access it.
In a new session PowerBi, go to the GetData tab and select " website ».
This is where you'll paste the URL:
Choose the table that contains the data, then click " load And choose the data table to import.
PowerBi now has access to the data:
click on " Report »To access the visualization tools and page 1 of your document (your canvas).
Click on " new visual »And choose the column of values (I took those of the error messages)
An error message appears in the window, this is normal for the moment.
This is because there is no associated value yet. To do this, you have to drag the data into values. By default, they will be counted by numbers.
It is not finished! The graphic is interactive. Hover your cursor over the row or click on it.
For the rest, in addition to the default color, I associated a color according to the degree of importance of the warnings. Just go to the color settings and manually change according to the types of warning.
To publish on the web, you must click on " publish », Which will transfer your table to your account PowerBi.
Updating the data, simple, just export your html file again and overwrite the old version, then press " refresh In PowerBi.
The result once shared : https://app.powerbi.com
Another version also : https://app.powerbi.com
The latter allows an analysis of the most common warnings per person. I will use these results, among other things, to intervene more precisely in order to correct bad habits of modeling or information entry in Revit.
Yien Chao | BIM influence
Architect, BIM Director and Computational BIM manager
Menkes Shooner Dagenais Letourneux architects
Microsoft Power Bi official site: https://powerbi.microsoft.com/fr-fr/