Autodesk Forma / ACC Power BI Integration Guide

Common Data Environments (CDEs) have become essential infrastructure for BIM developments in the AECO industry. Today, we’ll focus on one of the most widely adopted platforms: Autodesk Forma, including the workflows many teams still call Autodesk Construction Cloud (ACC). Autodesk has moved the construction cloud product family under the Forma name, but in real projects you will still hear ACC, BIM 360, Autodesk Docs, Model Coordination, and Forma used in the same conversation.

For Power BI reporting, the naming is less important than the workflow. Teams need a reliable way to move Revit, IFC, Navisworks, issues, model versions, and asset information from Autodesk-hosted projects into dashboards that project leaders can actually use.

However, while Autodesk Forma and ACC-style workflows are strong for collaboration and document management, translating that rich BIM data into actionable business intelligence remains a challenge. Many teams struggle to extract meaningful insights for executive dashboards, trend analysis, portfolio-level reporting, or model review meetings. This is where Frame’s Power BI integration transforms your Autodesk-hosted model data into model-aware analytics dashboards.

Frame’s broader Power BI construction dashboard workflow shows how ACC, Revit, IFC, and Navisworks data can feed model-aware reports.

Why Connect Autodesk Forma / ACC to Power BI?

Organizations invest heavily in Autodesk Forma and Autodesk Construction Cloud to centralize project data, but that data often remains siloed inside the platform. Power BI offers strong visualization, analysis, and reporting capabilities, but connecting it to BIM data has traditionally required complex custom development, manual exports, or connector flows that do not always match how BIM teams review models.

Here’s what makes Frame’s ACC to Power BI integration transformative:

• Unified Project Intelligence: Combine BIM data from multiple Forma or ACC projects into comprehensive portfolio dashboards that provide enterprise-wide visibility.
• Real-Time Decision Making: Access live model data and property information that updates automatically as your ACC projects evolve, eliminating outdated reports.
• Standardized Reporting: Create consistent analytics templates across all your projects, ensuring stakeholders see the metrics that matter most.
• Executive Visibility: Transform technical BIM properties into executive-friendly visualizations that communicate project status, quantity takeoffs, and clash metrics without requiring technical expertise.

How to Connect Autodesk Forma and ACC to Power BI

Understanding the Autodesk Connector for Power BI

Autodesk Connector Data Exchange for Power BI works by allowing you to fetch and load data from Autodesk Data Exchanges into Microsoft Power BI. This connector enables seamless integration, where design and model data stored in Autodesk Construction Cloud (ACC) can be imported and used in Power BI to create comprehensive reports and dashboards.

Here is how it works in detail:

• A Data Exchange is created in Autodesk Construction Cloud, often from a Revit 3D view or other BIM data sources.
• This Data Exchange stores subsets of the design/model data that can be shared and accessed in external tools.
• The Autodesk Data Connector is installed in Power BI, which provides a data source option to connect directly to these Data Exchanges.
• Once connected, data from the Data Exchange is imported into Power BI, where it can be transformed, filtered, analyzed, and visualized using Power BI’s capabilities.
• The connector also includes an Autodesk Viewer visual that can be added to Power BI dashboards for 3D model visualization alongside the data.
• Data Exchanges can be set to auto-update, so reports and dashboards in Power BI automatically reflect the latest design changes.
• This process facilitates advanced workflows such as progress tracking, material consumption prediction, asset management correlation, and improved collaboration across project teams.

The native connector works well for project management workflows, but it has limitations when the report needs to behave like a BIM review surface. It does not give every team a ready-made Revit Power BI template, a clear reusable model dataset, or a viewer workflow built around saved review states. You may still need to manually structure model data, adapt the result for IFC/Revit/Navisworks differences, and build the dashboard from scratch. Additionally, the basic viewer path does not cover the review features many BIM teams ask for: saved views, isolated element sets, persistent colors, markers, 2D sheet context, and selection sync with outside Power BI visuals.

Frame’s Integration Approach

Frame takes a different approach by connecting directly to your Autodesk Forma / Autodesk Construction Cloud projects through our Autodesk integration. Your original BIM files stay in your Common Data Environment (CDE). Frame accesses the model data needed to prepare reports, keeps the source workflow inside Autodesk, and generates clean, structured datasets ready for Power BI.

The goal is not just to export rows. The goal is to create a repeatable reporting layer for Revit, IFC, Navisworks, ACC issues, model versions, and assets.

What Frame Provides for Power BI

Frame’s Power BI integration delivers a complete, modern analytics solution with everything you need for comprehensive BIM data analysis:

• Ready-to-Use Templates: Pre-built Power BI dashboard templates (.pbit files) with all visualizations, measures, and relationships already configured. Simply download and connect—no manual setup required.
• Clean, Structured Datasets: Automatically transformed and optimized data tables that follow Power BI best practices. Frame starts from clear FRAME_Assets and FRAME_Properties queries so report authors can duplicate and shape them into custom tables without starting from raw Autodesk export structures.
• Custom Viewer for Power BI: Frame’s advanced 3D viewer integrates seamlessly into your Power BI dashboards, offering features the native Autodesk viewer lacks—including saved custom views, element isolation, multiple color-coding schemes, and 2D sheet visualization.
• Large-Model Architecture: Frame prepares BIM model data before the Power BI template opens, which keeps large Revit models and federated ACC workflows from pushing too much transformation work into Power BI.
• Multiple Template Options: Choose from various specialized templates tailored to different workflows: Quantity Takeoffs, Cost Analysis, Clash Resolution, Issues Management, Portfolio Analytics, and more.
• Modern User Experience: Intuitive, streamlined interface designed for both technical and non-technical users. Get from raw BIM data to actionable insights in minutes, not hours.

What Data Should Go Into the Power BI Model?

The most useful ACC or Forma dashboards usually combine a few stable data families:

• Assets and elements: object identifiers, category, family, type, level, source model, and display names.
• Properties: Revit parameters, IFC properties, Navisworks attributes, and values grouped into a table that can be filtered and duplicated.
• Versions: model publish dates, active versions, and comparison context.
• Issues and coordination data: status, assignee, priority, due dates, locations, linked objects, and resolution metrics.
• Viewer state: saved views, isolated element sets, color rules, and marker context that can be reused in review meetings.

This data shape is where Frame differs from many connector-first workflows. Instead of leaving every report author with a raw model export, Frame gives the report a clearer starting point. The common pattern is to keep FRAME_Assets and FRAME_Properties as the base queries, duplicate them for custom report tables, and then build visuals from those prepared tables. That keeps the dataset readable and reduces the chance that a large model becomes hard to refresh or maintain.

Why the Viewer Matters Inside Power BI

An Autodesk Forma or ACC Power BI dashboard should not only show totals. It should let the team verify the model objects behind those totals.

Frame’s Power BI viewer is based on Autodesk Viewer technology and extended for dashboard review work. Teams can apply colors, place markers, save views, save isolated element sets, and preserve color states for future meetings. The viewer can also interact with outside Power BI visuals: a chart selection can isolate objects in the model, and model selections can drive the report context.

For a deeper look at this workflow, see Autodesk Viewer in Power BI: Custom BIM Models Inside Reports.

Where Frame Fits Compared With Autodesk Data Exchange

Autodesk Data Exchange is useful when a team wants to share a curated subset of design or project data. Frame is focused on model-aware reporting: large BIM models, Power BI templates, custom datasets, and viewer interaction.

Use Autodesk Data Exchange-style workflows when the team needs a specific exchange of design data between tools. Use Frame when the dashboard needs Revit or ACC model objects, object properties, saved viewer state, and a Power BI dataset that is already shaped for construction reporting.

This matters most on bigger projects. In our own comparisons with Data-Exchange-style workflows, large models are often the stress test. Frame’s pipeline is designed to do the heavy model preparation before the Power BI report opens, then serve the report tables and viewer state in a way the dashboard can use.

Here’s how to set up Frame’s Autodesk Forma / ACC Power BI integration:

Prerequisites

Before you begin, ensure you have:

• An active Autodesk Construction Cloud account with model access
• A Frame account (sign up here)
• Frame’s ACC integration installed from the ACC App Catalog
• Power BI Desktop or Power BI Service access

If you haven’t installed Frame’s integration from the ACC App Catalog yet, follow our Autodesk Construction Cloud Integration Guide guide

Step 1: Add Models from ACC to Frame

Once you’ve installed Frame’s integration from the ACC App Catalog, connecting your models is straightforward.

1. Navigate to Your Frame Dashboard

• Log in to your Frame account
• Click “Add Model from ACC” on the main dashboard

2. Connect to Your ACC Project

• If you’ve already installed Frame’s integration in the ACC App Catalog, you’ll see a dialog listing your accessible projects
• If not, you’ll be prompted to install the integration first (see our Autodesk Integration Guide)

3. Select Your BIM Files

• Browse your ACC project folders and select supported BIM files (Revit, Navisworks, IFC formats)
• Click to add the model to Frame
• Important: Your original file never leaves your CDE—Frame only accesses the model translation data from ACC
• Processing time varies based on model complexity (typically 2-10 minutes)

Step 2: Access Your Power BI Dashboard

After Frame processes your ACC model, clean datasets are automatically created and ready for Power BI.

1. Wait for Processing to Complete

• Frame automatically extracts all properties, elements, and metadata
• You’ll receive a notification when processing is complete
• Frame structures the data into query-ready formats optimized for Power BI

2. Create Your Power BI Report

• Navigate to the processed model in your Frame dashboard
• Click “Create Report” on the model card
• Frame provides ready-to-use Power BI templates pre-configured with:
  • Elements Table: All model objects with their basic properties (name, category, family, type)
  • Properties Table: Detailed property values organized by category
  • Hierarchy Table: Model structure and relationships
  • Pre-built Visualizations: Common dashboards for quantity takeoffs, cost analysis, and project metrics

3. Download Your Template

• Select from available Power BI templates based on your analysis needs
• Download the .pbit (Power BI template) file
• Templates come pre-configured with all necessary data connections and relationships

Step 3: Open Template in Power BI

Opening your Frame-generated Power BI dashboard is simple and requires minimal setup.

1. Open Power BI Desktop

• Launch Power BI Desktop
• Open the downloaded .pbit template file from Frame

2. Connect to Your Frame Data

• Power BI will prompt for connection details (already pre-configured in the template)
• Authenticate using your Frame credentials when prompted
• The template automatically loads all necessary tables and relationships

3. Explore Your Dashboard

• Your dashboard is immediately ready with pre-built visualizations:
  • Quantity Charts: Element counts by category, family, or level
  • Property Analysis: Parameter values across project phases
  • Spatial Breakdowns: Floor-by-floor or zone-based metrics
  • Timeline Views: Track changes across model versions

4. Customize (Optional)

• Modify visualizations to match your specific reporting needs
• Add custom measures or calculated columns
• Frame’s data model follows Power BI best practices with clear primary/foreign keys, making customization straightforward

Step 4: Enable Automatic Updates (Optional)

For ongoing projects where ACC models update regularly, Frame offers automatic synchronization to keep your Power BI dashboards current.

1. Toggle Automatic Model Updates

• In your Frame dashboard, navigate to the model settings
• Enable “Automatic Model Updates”
• Frame will monitor your ACC project for new model versions
• When a new version is detected, Frame automatically processes it and updates your datasets

2. Configure Issue Webhooks

• Enable issue webhooks to receive notifications when model updates are processed
• Get alerts when processing completes or if any issues occur
• Stay informed about your data pipeline status without manual checking

This creates a true real-time Autodesk Construction Cloud Power BI integration that updates as your project evolves, giving you the best experience with minimal manual intervention.

Example Use Cases

Frame’s Autodesk Forma / ACC Power BI integration powers diverse analytics scenarios:

• Portfolio Dashboards: Aggregate data from multiple ACC projects to compare performance, track quantity trends, and identify optimization opportunities across your project portfolio.
• Executive Reporting: Create high-level visualizations showing project status, completion percentages, and key metrics without requiring stakeholders to navigate complex BIM software.
• Quantity Takeoff Tracking: Monitor material quantities over time as models evolve, comparing planned vs. actual quantities or tracking changes across design iterations.
• Clash Resolution Analytics: If using Navisworks models from ACC, visualize clash detection results, track resolution status, and identify patterns in coordination issues.
• Issues Management & Performance Analytics: Track and analyze ACC issues directly in Power BI with Frame’s Issues template. Monitor resolution performance, analyze assignee workloads, identify bottlenecks, and measure average time-to-resolution across projects. Gain insights into issue distribution by type, location, and priority to improve team productivity and project delivery timelines.
• Cost Analysis: Combine Frame’s BIM property data with cost databases in Power BI to create cost-loaded schedules and budget tracking dashboards.

FAQ

Is Autodesk Construction Cloud now Autodesk Forma?

Autodesk has moved Autodesk Construction Cloud into the Autodesk Forma industry cloud. Many teams and search results still use the ACC name, so it is practical to write and search for both “Autodesk Forma” and “Autodesk Construction Cloud.”

Can Revit models from ACC be used in Power BI?

Yes. With Frame, teams can connect ACC-hosted Revit models, process the model data, and generate Power BI templates with assets, properties, versions, and 3D viewer context.

Can Frame handle large Autodesk models?

Frame is designed around large BIM model reporting. Model processing happens before the Power BI template opens, and the report receives structured datasets instead of forcing Power BI to do every heavy transformation at open time.

Does Frame replace Autodesk Data Exchange?

No. Autodesk Data Exchange is useful for certain exchange workflows. Frame is focused on BIM reporting workflows where teams need Power BI templates, clean datasets, large-model support, and an interactive model viewer inside the report.

Conclusion

The combination of Autodesk Forma / ACC collaboration and Power BI’s analytical capabilities can unlock practical insights from BIM data. You no longer need to choose between project collaboration and model-aware reporting. With Frame, your ACC or Forma models become living data sources that support review meetings, executive reporting, quantity takeoffs, issue analysis, and portfolio visibility.

Whether you’re managing a single project or an enterprise portfolio, Frame’s Autodesk Forma / ACC Power BI integration reduces the technical barriers that have historically kept BIM data separate from business intelligence.

Ready to transform your ACC data into actionable Power BI dashboards? Get started with Frame today and see how easy BIM analytics can be.

---

For more information on setting up your Autodesk integration, check out our Autodesk Integration Guide. To explore other Frame capabilities, visit our Power BI Integration Features.