Which approach is best to create a unified table for reporting?
hard📝 Scenario Q15 of 15
Power BI - Getting Data
You want to combine data from an OData feed and a REST API in Power BI. The OData feed provides product details, and the REST API returns live stock levels as JSON. Which approach is best to create a unified table for reporting?
AUse <code>OData.Feed()</code> to get products, <code>Web.Contents()</code> + <code>Json.Document()</code> for stock, then merge tables in Power Query.
BUse only <code>OData.Feed()</code> for both sources since it supports all APIs.
CImport REST API JSON as CSV and append to OData feed table directly.
DLoad both sources separately and create relationships in the data model without merging.
Step-by-Step Solution
Solution:
Step 1: Connect to each data source appropriately
Use OData.Feed() for the OData product details and Web.Contents() with Json.Document() to parse REST API stock JSON.
Step 2: Combine data in Power Query
Merge the two tables on product ID to create a unified table before loading into the report.
Final Answer:
Use OData.Feed() to get products, Web.Contents() + Json.Document() for stock, then merge tables in Power Query. -> Option A
Quick Check:
Combine sources with correct connectors and merge [OK]
Quick Trick:Use correct connectors per source, then merge in Power Query [OK]
Common Mistakes:
Trying to use OData.Feed() for REST API JSON
Appending JSON as CSV without parsing
Not merging data, just relating tables
Master "Getting Data" in Power BI
9 interactive learning modes - each teaches the same concept differently
