Autodesk Construction Cloud

Note

This connector is owned and provided by Autodesk.

Summary

Property Value
Connector Autodesk Forma icon Autodesk Forma
Products Power BI (semantic models)
Power Query Online
Release state General availability
Category Online Services
Authentication kinds OAuth
Data source kind AutodeskConstructionCloud
Function Reference Documentation AutodeskConstructionCloud.Contents
AutodeskConstructionCloud.Feed
Support link Support

Prerequisites

To use the Autodesk Construction Cloud connector, you must have an Autodesk account with a username and password and have access to the Executive Overview in a BIM360 or an ACC Account. You also need to run a Data Connector extraction manually or have the extractions scheduled to run in order to use this connector. The Connector pulls from the last ran extract.

Supported capabilities

  • Import
  • Supports United States, Europe, and Australia Autodesk Construction Cloud servers

Parameters

Entry point: AutodeskConstructionCloud.Feed

Required parameter count: 1

Parameter Display name Required Type Description Allowed values Nullable Additional metadata Declared allowed values
region Region Yes text The type that represents all text values. "Australia"; "Canada"; "Europe"; "Germany"; "India"; "Japan"; "UK"; "United States" false {"Documentation.Category": "", "Documentation.Examples": [], "Documentation.LongDescription": "The type that represents all text values.", "Documentation.Name": "Text.Type"} ["Australia", "Canada", "Europe", "Germany", "India", "Japan", "UK", "United States"]

Connect from Power Query Desktop

To connect to Autodesk Construction Cloud data:

  1. Select Get Data from the Home ribbon in Power BI Desktop. Select Online Services from the categories on the left, select Autodesk Construction Cloud, and then select Connect.

  2. If this is the first time you're getting data through the Autodesk Construction Cloud connector, a preview connector notice will be displayed. Select Don't warn me again with this connector if you don't want this message to be displayed again, and then select Continue.

  3. Select the Autodesk server region (United States, Europe, or Australia), and then select OK.

    Screenshot of the Autodesk Construction Cloud server region selection.

  4. To sign in to your Autodesk account, select Sign in.

    Screenshot showing the Autodesk Construction Cloud Sign in button.

  5. In the Autodesk window that appears, provide your credentials to sign in to your Autodesk account.

    Screenshot of the Autodesk sign-in page.

  6. Once you've successfully signed in, select Connect.

    Screenshot showing Autodesk Construction Cloud signed in and ready to connect.

  7. In Navigator, expand the Account you want to pull data from, which will display an Account Extract folder and a Project Extracts folder. Account Extract will contain the data extract of the most recent account level extract if you have proper access and have ran an account level data extract. Project Extracts will contain a listing of each project in the account you have access to, which you can then expand to see the relevant tables in that specific project's extracts if you have run a data extraction.

    Screenshot showing data extraction selection in Autodesk Construction Cloud.

  8. Once you navigate to the desired Account or Project extract, select the desired tables, and then either select Load to load the data or Transform Data to continue transforming the data in the Power Query editor.

    Screenshot showing data tables and the Load and Transform Data options.

Additional information

Connect using provided Power BI templates

  • Download the latest Power BI Templates from the Template Gallery within Data Connector.

    Screenshot showing the Power BI Template Gallery in Data Connector.

  • Only templates with "...(Connector).." in the file name are set up to work with this connector.

To use the Power BI Templates:

  1. Open a template file.

  2. Provide your ACC Account name and select the server region.

    Screenshot of the ACC account name and server region fields.

    Note

    The Account Name is the name of the ACC account you want to connect to, not your user account name. You can find the Account name on the Account Admin portal just to the right of the Account Admin drop down or under Settings. The Account name also appears on the Insight (Account) page just to the right of the Insight dropdown in the upper left hand corner.

    Screenshot showing the account name on the Account Admin portal.

  3. If prompted, follow steps 4 through 6 in the previous procedure to sign-in and connect.

Limitations and considerations

You should be aware of the following limitations and issues associated with accessing Autodesk data.

  • This connector pulls data from the last run Data Connector extract and not the live data from the account.