Linking your OData Feed to a OdataLink Standard Excel Report Template

Copy the Consolidation OData Feed

Select the existing OData feed url

OdataLink provides a set of downloadable Excel Report templates which are linked to OData Feeds of a demo company file.

In order to replace the existing demo company data with your data in the report, replace the existing OData feed as a Data Source to your own OData feed url.

The following guide will assist in linking your data to the report template.

Steps

Enter the OData Feed url

To link your company OData feed with OdataLink standard report template, follow these steps.

Before beginning, ensure you have copied the Consolidation OData Feed URL, highlighted in the first image.

1. Open Microsoft Excel on your desktop and select the Data tab.
2. Click on the Get Data button, then select Data Source Setting.

   Note that on some version Excel, the Get Data button is called New Query instead.

3. In the Data Source Settings dialogue, select the OData feed url and click on Change Source.
4. In the next dialogue, paste the OData Feed URL copied previously and click OK.
5. The report would refresh and download your company data into the report.

Related Topic

Integrating OdataLink with Microsoft Excel

Linking your data to a Standard Microsoft Power BI Report