You want to optimize refresh performance when connecting to a REST API that returns paged JSON data. What is the best practice?

hard📝 Scenario Q9 of 15

Power BI - Getting Data

AUse recursive Power Query functions to fetch all pages before loading data

BLoad only the first page and ignore the rest

CUse OData.Feed instead of Web.Contents for paging

DManually copy JSON data into Excel and import

Step-by-Step Solution

Solution:

Step 1: Understand paged REST API data
Many REST APIs return data in pages; to get all data, multiple calls are needed.
Step 2: Use recursive Power Query to fetch all pages
Recursive functions can call the API repeatedly until all pages are retrieved, improving refresh completeness and performance.
Final Answer:
Use recursive Power Query functions to fetch all pages before loading data -> Option A
Quick Check:
Recursive calls handle paging efficiently [OK]

Quick Trick: Use recursion in Power Query to handle API paging [OK]

Common Mistakes:

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes