Large Volume of data broken into chunks with multiple API Calls

[icassiem]

Good day, 

I have posted in service but thought this might be suited to desktop

I have a large dataset (1m records), we are trying to provide the data to a client via an API that has a param for orgID and areaID

The API only returns the dataset for the combination of orgID + areaID

"Me thinking out loud"

1. For powerbi to load all data, should i do a loop and meaning get a list of orgID + areaID and execute the API per combination and append the dataset > How ?

2. Not sure if Direct Mode can do this, as the API was developed on the bases of Lazy load similar to an app based on user selection fetches data for the selection - but this is not what i understand of pbi

Please what other options do i have, as loading the data in a storage layer is not an option as its built for external clients power users?

Please Any Help, Thanks

[foodd · Accepted solution]

Hello @icassiem , as this is a duplicate Community Forum Post of the one added  to the Power BI Service Board, and that it is being replied to, would you please close this post.

https://community.fabric.microsoft.com/t5/Service/Large-Volume-of-data-broken-up-in-chunks-with-mult...

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[icassiem]

Apologies & Thank You @foodd , i marked it as a solution as I could not close or delete