In this topic we will demonstrate how the exported warnings data from Ideate Explorer can be used with Power BI to visualize the relative severity of warnings across one or more Revit projects. A similar workflow is also available for use with Excel. The example files referenced below are available by request for Ideate Explorer subscribers: REQUEST DATASET. This workflow requires the April 2021 (or later) version of Microsoft Power BI.
To begin, extract the contents of the file provided to a new folder. In this example we will place the files within a new folder called Test Project. The files included in the zip file are:
The IdeateExplorer-RevitWarnings.pbit file contains the dashboard visualizations and references the warnings data found in the folder called Ideate Explorer Warnings Export. To ensure that this file can properly read the sample warnings data, review the data source setup by following these steps:
At this point you should see two tabs within Power BI.: Single File and Multiple Files. See below for details on the purpose of each.
The Single tab allows the user to select from the list of sample files to drive a bar chart which shows the number of warnings per each of the specified Ideate Explorer warnings rankings. The focus for this tab would be in looking at the number of high rankings (red) per each file to assess which project might need the most help.
The Multiple Files tab contains two data visualization. The top chart, called Warnings Count, shows the number and rank for the warnings of each file in the list. Projects with the most warnings are likely to have the most performance problems, however, understanding the number of warnings in the context of the file size is generally understood to be the more important Revit health metric. For this reason we are also providing the bottom chart, called Warnings per MB. In this chart the number of warnings is scaled according the file size of the project and there is the addition of a red line which represents the Ideate Explorer warnings threshold, generally set at 1 warning per megabyte of file size.
You can create your own Ideate Explorer warnings data by exporting the data as described in this related Help topic: How Do I Export BIM Data? To include additional data files for use with the Power BI project, see below for detailed instructions.
If you wish to use your project data with the above template information, then follow these steps
If you want to share your Power BI data visualization via a URL, follow these optional steps:
Thank you for taking time to inform us about a bug or feature request.