Edit

Autodesk Construction Cloud

  • Article

Note

The following connector article is provided by Autodesk, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the Autodesk website and use the support channels there.

Summary

Item Description
Release State General Availability
Products Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Autodesk account
Function Reference Documentation —

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.

Capabilities Supported

  • Import
  • Supports US and EU Autodesk Construction Cloud servers

Connect to Autodesk Construction Cloud data

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 (US or EU), and then select OK.

    Select server region.

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

    Select sign in button.

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

    Sign in to Autodesk.

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

    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.

    Navigate to the desired data extraction.

  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.

    Navigate to data tables and load or transform data.

Connect using Autodesk provided Power BI Templates

To use the Power BI Templates:

  1. Open a template file.

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

    Provide ACC Account name and select server region.

    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.

    Account name can be found on the Account Admin portal.

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

Limitations and issues

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

  • Autodesk returns a 404 error status if you don't have any request in the last 30 days.
  • This connector pulls data from the last run Data Connector extract and not the live data from the account.