Create a Power BI Dashboard

This help file outlines how to export model health data from a Revit file using Ideate Automation and display it in Power BI. This process will reduce the amount of hands-on time needed in order to ensure project stability and consistency across your Revit project files. The PowerBI template can be modified to suit your company’s needs.

Contents:

Software Requirements
Initial Setup
Ideate Automation
     Create the Ideate Automation task
     Set the script variables
     Start Automation task
Power BI
     Loading data into PowerBI
     Visualizations
     Customize Data Folder

Software Requirements

Before you begin, check that your setup can meet these requirements:

Initial Setup

The PowerBI template and associated files can be requested by Ideate Software subscription customers. You will receive an email from Ideate Software support with a download link.

Download the zip file, unpack it and double click the Ideate Dashboard Files.exe. Pick ‘Unzip’ to place the contents in the default C:\<root> location. 

The following folders will be created on your ‘C:\’ drive:

Ideate Automation

Create the Ideate Automation Task

  1. Launch Ideate Automation, which runs outside of Revit. The shortcut can be found on your Desktop after installation.
  2. Select Create to start a new task.
  3. From the Ideate Software Scripts folder, select the subfolder called “02 Health Check”, then pick the script on the right pane called “ISW-Health_Check-PowerBI”.
  4. Review the description of this task and note the product requirements, then pick Next.

Set the Script Variables

  1. Fill in the script variables:
    • Revit Files — select one or more Revit files to process for a health check. Go to ‘Manage’ if you have not added the files into your Automation list yet.
    • Export Location —  browse for a location to save the Excel data files. It should be your Data Folder, per the details in the File Setup section above. You can save the results to your local drive or to BIM 360 / ACC as well.
  2. Select Next, review all inputs on the Confirm Task Selections page and select Next again. 

Start the Automation Task

  1. Check that Revit is not running. While it is OK to run Revit of a different year version than the one(s) needed by the Automation task, this is not recommended, especially if you use a single display. 
  2. Select Create and Run to start the task. Revit should open and the automated health check should begin. The process can take some time, especially on large and complex models.
  3. Once the task is complete, you will see ‘Completed’ in the task Status field (Ideate Automation Home Page)
  4. The result of this process is a uniquely named Excel file for each of the selected Revit files, located in the Data Folder.

Power BI

Loading Data into Power BI

The .pbit file contains the dashboard visualizations and references the data found in the folder called Ideate Health Check. 

  1. Open the .pbit file with Power BI, either by double-clicking on the file or in Power BI, select File>Open Report>Browse Reports.  Be sure to change file type to Power BI template files (.pbit) when browsing for the template. After starting Power BI, a dialog appears
  2. Select ‘Load

  1. If you see a pending change to queries, select Apply Changes.
  2. It is a best practice to refresh the data in Power BI — Home Tab > Queries Panel > Refresh.

Visualizations

 

Customize Data Folder

To change the Data Folder location (local hard drive or cloud/network location):

  1. Go to File > Options and Settings > Data source settings to adjust the data locations.
  2. Select the data source, which in our sample content is the folder called C:\ideate health check, then use the Change Source…button to browse to the new file path.


Note: This new folder path must include an excel file that’s formatted to be read by Power BI template. You can either use the data we provide or place an export from Ideate Automation that’s been created from the ISW-Health_Check-PowerBI script into that folder directory.

  1. Click OK to close, then select the option at the top to Apply Changes.
  2. If you want your Power BI template to read from that new location all the time, you can save as Power BI template file (*.pbix) after redirecting to the data source file.

Related topic: Power BI — Publish to Autodesk Construction Cloud

 

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.