Consolidation OData Feed
Overview
Consolidation OData Feeds are specialised feeds that allow you to pull data from multiple 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 files into one table in Power Query.
For the most part, the Endpoints access via a consolidation OData feed are the same as those for individual data files. Both include a Data File ID.
OdataLink Report Templates require Consolidation OData Feeds
Standard OdataLink Report templates require Consolidation OData 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 OData feed includes additional Functions. These functions include ID parameters, such as BudgetID, TrackingCategoryID, etc.
Since these ID parameters are specific to a single Data File, Standard templates include additional syntax to specify the DataFile IDs of all datafiles assigned to a model.
Thus, using any OData feed other than Consolidation OData Feed will result in errors while refreshing the Standard report template.
Enable Consolidation OData Feed for a Model
Consolidation OData Feed must be enabled in order to be used.
Please refer to Enabling access to the Consolidation OData Feed for the model to enable Consolidation OData Feed.
Related Topics
Key Words
Consolidate
Consolidation OData Feed
Consolidation End Points
Consolidate Xero Organisations
Consolidate MYOB Companies
Consolidate multiple data files