Share

Connect to Microsoft® Power BI Desktop

The certified Autodesk Construction Cloud connector is available to members with the April 2022 Power BI Desktop release.

Members with executive access can now streamline the data extraction process and set a schedule for their Power BI dataset to be updated automatically with the latest Data Connector extract.

Prerequisites

Note: Autodesk Construction Cloud connector pulls data from the last run Data Connector extract and not the live data from the account.

Add Autodesk Construction Cloud Connector

  1. Open Power BI desktop (April 2022 release)

  2. Click Get data from the Home ribbon

  3. Click More... in the drop-down list

  4. In the Get Data dialog box, search for Autodesk Construction Cloud, or select Other on the left side and scroll until you find it

  5. Click Connect

If this is the first time you're getting data through the Autodesk Construction Cloud connector, a Connecting to a third-party service dialog box will display.

  1. Select Don't warn me again with this connector if you don't want this message to be displayed again

  2. Click Continue

  3. Select which Autodesk server region (US or EU) you want to connect to

  4. Click OK

You now need to sign in with your Autodesk credentials.

  1. Click Sign in

  2. Sign in with your Autodesk credentials

  3. Click Connect once you're signed in

  4. In Navigator, expand the account you want to pull data from, 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.

Note: If you have the appropriate Power BI license, you can publish your dashboards to the Power BI web service where you can set up scheduled refresh for your dataset to be updated automatically.

Publish to Power BI Web and Schedule Refresh

If you are publishing your Power BI dashboard to the Power BI web service, you will need to perform the following steps to set up the schedule refresh in Power BI web to automate your dashboard dataset updates.

Note: You need to be signed in to your Power BI desktop and web accounts.

  1. Set up a scheduled extraction in Data Connector.

  2. Open Power BI desktop and click Publish

  3. Click Save.

  4. Select the workspace you want to publish to.

  5. Click Select.

  6. After the file finishes publishing, click the link in the dialog box or go to https://app.powerbi.com/

  7. Click Workspace on the left side of Power BI web and select the workspace you published your file to.

  8. Click the Datasets + dataflows tab

  9. Hover the cursor over the dataset with the same name as your Power BI file and click the more menu

  10. Click Settings.

  11. Expand Data source credentials and click Edit credentials.

  12. Sign in with your Autodesk credentials to allow the Power BI web service to refresh your data.

  13. Expand Schedule refresh and toggle it on.

  14. Set up your Refresh frequency, Time zone, Time and any additional settings.

Note: Allow a few hours delay between the scheduled extraction time in step 1 above and the Time of your Power BI scheduled refresh.

  1. Click Apply.

Parent page: Data Connector

Was this information helpful?