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

15@15: Mastering Revit Key Schedules with Ideate BIMLink
By Kim DeLashmit June 9, 2025
TRAINING - VIDEO | Master Key Schedules in Revit with Ideate BIMLink. Learn how to create, manage, and optimize them for better data control and project efficiency. Take your Revit data management to the next level with Ideate BIMLink.
The Wait Is Almost Over: Upcoming Release of Ideate Software for Revit 2023–2026!
By Kim DeLashmit June 9, 2025
NEWS - ARTICLE | We know many of you have been eagerly awaiting the next release of Ideate Software—and we’re just as excited to share it with you! In late June, we’ll be launching updated versions of the Ideate Software bundle for Autodesk Revit 2023 through 2026. Whether you’re working in the latest version or supporting projects in previous releases, this update is for you.
15@15: Picture Integration: Embedding Excel Images in Revit
By Kim DeLashmit May 20, 2025
TRAINING - VIDEO | Import and scale embedded Excel images in Revit with Ideate Sticky. Enhance project communication by seamlessly integrating visuals into your Revit files.
15@15: Excel-lent Start-Up Views in Revit
By Kim DeLashmit May 5, 2025
TRAINING - VIDEO | Integrate Excel data seamlessly into Revit with Ideate Sticky. Create and publish information sheets as startup views for instant access to key project details. Enhance communication and efficiency with Ideate Sticky.
Show More