Consolidation OData Feed

Overview

Consolidation Endpoints are specialised endpoints that allow you to pull all data from data files assigned to the model as a single feed.

They assist with the consolidation process by removing the need to append data from multiple data file specific end points into the one table in Power Query

The consolidation Endpoints created by model are the same as those for individual data files. Both include a Data File ID

Note that consolidation endpoints must be enabled in order to be used. See enabling access to the consolidation endpoints for the model for more information.

OdataLink Report Templates

Standard OdataLink Report templates utilize Consolidation Feeds to extract data.

Since Consolidation feeds are available for both single-organisation and multi-organisation accounts, using Consolidation feeds in the standard templates ensure that they are compatible with all accounts.

The consolidation endpoint functions contain a company field (DataFile ID) as a parameter, which is not available in standard company endpoints.

Thus, using a Company Odata Feed instead of Consolidation will result in errors while refreshing the report.

Related Topics

Endpoints

OdataLink Report Templates

Key Words

Consolidate

Consolidated End Points

Consolidate Xero Organisations

Consolidate MYOB Companies

Consolidate multiple data files