Ideate Automation: Understand Revit Model Health Using Microsoft Power BI

Revit users and BIM managers need to understand Revit project health. Often the project data metrics (warnings, in-place families, annotation, model groups, and views not on a sheet) are time consuming to collect and quantify. Unaddressed issues pile up over time and can take a long time to track and correct.


Ideate Software, with the use of Ideate Automation and Microsoft Power BI, created an automation script and Power BI template to address Revit model health issues.


For BIM managers looking to visualize curated details of their Revit model health, such as the project data metrics, and wanting to visualize these metrics in Microsoft Power BI, Ideate Software developed a Power BI template.

Ideate Automation with Power BI

With this Power BI template, BIM users can understand the following Revit model issues:


  • Project Information including total Revit warnings and warnings per file size
  • Revit Warnings over Time
  • Top 5 Warnings as defined and managed by Ideate Explorer
  • Model Groups
  • Views Not on Sheet
  • Average Annotation Issues per Sheet as defined and managed by IdeateApps>Annotate
  • CAD Imports (with Details)
  • In-Place Families (with Details)


For more details, and step-by-step instructions visit the Help file.


Current Ideate Automation subscribers can request the Power BI template files by contacting support@ideatesoftware.com.

Explore recent posts

Material Passports and Ideate Software with Ideate BIMLink and Ideate Automation
November 25, 2025
TRAINING - ARTICLE | One specific area of digital transformation, regulatory shifts, or market demands is the Circular Economy  - which aims to eliminate waste and keep materials in use for as long as possible.
DWG Exports to ISO 19650 using Ideate Automation
November 25, 2025
TRAINING - ARTICLE | Creating DWG exports from Revit models is still an important deliverable in most AEC projects. When exporting to DWG from Revit, there is no way to control the names of the resulting dwg exports. We are limited to the choice of Short (sheet number) or Long (Revit model name, sheet, etc.).
Generate Curtainwall Elevations in Revit Using Ideate ViewCreator
November 19, 2025
TRAINING - VIDEO | Easily create curtain wall elevations in Revit! Creating curtain wall elevations doesn’t have to be time-consuming. With Ideate ViewCreator, you can quickly generate curtainwall elevations from 2D view or 3D elements customize view naming, apply view templates, avoid duplication, etc.
Generate Material Quantity Takeoffs Using Ideate BIMLink
November 19, 2025
TRAINING - VIDEO | Generate material quantity takeoffs in Revit… automatically! Say goodbye to manual material exports. With Ideate BIMLink’s new ‘Material_QTO link definition, you can quickly export material instance data, areas, and volumes directly from your Revit projects.
Show More