BuildingConnected (Beta)

  • 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 Preview
Products Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Autodesk account
Function Reference Documentation —

Prerequisites

To use the BuildingConnected connector, you must have a BuildingConnected account that has been linked to your AutodeskID. An active Bidboard Pro subscription is required to access Opportunity data and an active TradeTapp subscription is required for TradeTapp data.

Capabilities Supported

  • Import
  • Supports BuildingConnected and TradeTapp accounts

Connect to BuildingConnected data

To connect to BuildingConnected data:

  1. Select Get Data from the Home ribbon in Power BI Desktop. Select Online Services from the categories on the left, select BuildingConnected & TradeTapp, and then select Connect.

    Screenshot showing BuildingConnected & TradeTapp connector.

  2. If you're getting data through the BuildingConnected & TradeTapp connector for the first time, a preview connector notice is 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 Sign in and use your Autodesk credentials to connect to your BuildlingConnected or TradeTapp account.

    Screenshot showing Select sign in button.

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

    Screenshot showing Sign in to Autodesk dialog.

  5. Once you successfully sign in, select Connect.

    Screenshot showing Signed in and ready to connect dialog.

  6. In the Navigator, select the data type you want to load to see a preview in the right pane. You can then load or transform the data. If you select Load, all records are loaded in to the Power BI model. It might take several minutes for all records to load depending on the number of objects.

    Screenshot showing Navigate to the desired data type.

  7. Optionally, you can use the Range Start and Range End inputs on the BuildingConnected function to load data based on the updatedAt query parameter. This allows you to implement incremental refresh to load only updated data once the initial data load has been ingested. To use the input dialog for these dates, select a table and transform it to load it in to Power Query. Then select the gear to the right of the Source step. Range Start and Range End are optional parameters. Using Range Start only provides all records updated on or after the provided Range Start date. Using Range End only provides all records updated on or before the provided Range End date. Providing both dates constrains to records updated between the two dates.

    Screenshot showing Optional range start and range end query parameters.

  8. Some data types contain nested records and lists that might need to be expanded to see all data fields. Expand each Record and List items as needed to see all fields.

    Screenshot showing Expand nested records.