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
Create the Ideate Automation task
Set the script variables
Start Automation task
Loading data into PowerBI
Visualizations
Customize Data Folder

Software Requirements

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

Initial Setup

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, then 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 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. To ensure that this file can properly read the project data, review the data source setup by following these steps:

  1. Open the .pbit file with Power BI, either by double-clicking on the file or in Power BI, 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, then use the Change Source…button to browse to the new file path.
  3. Click OK to close, then select the option at the top to Apply Changes.
  4. It is best practice to go to Multiple Files tabs and pick some radio buttons for the data to refresh.

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.