Linking your data to a Standard Microsoft Excel Report

Select the existing OData feed url

OdataLink provides a set of downloadable PowerBI Report templates which are created using a demo data URL.

Once you download a report, the downloaded report will contain the demo data.

In order to see your data in the report, you would need to replace the existing OData feed power query to your own OData feed url.

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

Steps

Enter the OData feed url

To link your OData feed power query in Microsoft Excel, follow these steps.

Before beginning, ensure you have copied the OData Feed URL.

1. Within Excel, select the Data tab.
2. Click on the Get Data button, then select Data Sources 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.

Related Topic

Integrating OdataLink with Microsoft Excel

Linking your data to a Standard Microsoft Power BI Report