Embedded Files
There are a TON of good Revit Dashboard workflows and paid services out there.
Here's an example of how you can use Dynamo and Power BI to automatically generate a dashboard containing key information about the Revit model, which can then be run on any Revit model.
The Script:
The Script:
Extracting Room Names with Dynamo is all well and good, but to get the useful data I really wanted, I used a combination of OOTB nodes and the following packages:
designtech, Clockwork, archilab, Data-Shapes, MEPover
With this, we can grab the Filename, File Size, Project Information, a List of Users, Worksets, Phases, Warnings, Families, Family Types, etc, etc, etc.
As we are exporting to Excel, we want to add a header at the top of each Column, as this will be used as the Field Title in Power BI.
To do this, we can insert this at the top of the list in Dynamo.
Once we have all our lists, we can feed these into a List Create.
As the Data.ExportExcel node will write each sub list as a row, we need to first Transpose the List before it gets plugged into the data input.
Rather than naming and saving the file manually, we can get Dynamo to create a folder, based on the Project Name parameter value, and automate the naming of the excel file by combining the Building Name parameter value and the current date:
The Power BI Dashboard
The Power BI Dashboard
We can use 'Get Data' in Power BI and start setting up visualisations to end up with something like this. Here I am conditional formatting the colour to give an indication on good/bad items, such as a large File Size or high No. of Warnings.
From then on it's easy...
From then on it's easy...
Each time you want to create a Model Audit Dashboard, just Run the Dynamo script, then in Power BI point to the new Excel File. (Edit Queries --> Data Source Settings --> Change Source --> Browse)
Page updated
Google Sites
Report abuse