BuildingConnected (Beta)
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:
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.
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.
Select Sign in and use your Autodesk credentials to connect to your BuildlingConnected or TradeTapp account.
In the Autodesk window that appears, provide your credentials to sign in to your Autodesk account.
Once you successfully sign in, select Connect.
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.
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.
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.
