OData and REST API connections in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample data retrieved from an OData REST API connection showing user IDs, names, and countries.

Cell	Value
A1	ID
B1	Name
C1	Country
A2	101
B2	Alice
C2	USA
A3	102
B3	Bob
C3	Canada
A4	103
B4	Charlie
C4	UK

Formula Trace

OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/Customers")

Step 1: OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/Customers")

Step 2: Table.SelectColumns(result, {"CustomerID", "CompanyName", "Country"})

Step 3: Table.RenameColumns(result, {{"CustomerID", "ID"}, {"CompanyName", "Name"}})

Cell Reference Map

   A       B        C
1  ID      Name    Country
2  101    Alice      USA
3  102     Bob     Canada
4  103  Charlie       UK

The table columns ID, Name, and Country come from the OData API response after selecting and renaming.

Result

   A       B        C
1  ID      Name    Country
2  101    Alice      USA
3  102     Bob     Canada
4  103  Charlie       UK

The final table shown in Power BI after connecting to the OData REST API, selecting, and renaming columns.

Sheet Trace Quiz - 3 Questions

What does the OData.Feed function do in Power BI?

A It filters rows in a table.

B It connects to an OData REST API and retrieves data as a table.

C It creates a chart from existing data.

D It renames columns in a table.

Key Result

OData.Feed connects to an OData REST API URL and returns data as a table, which can be filtered and renamed.