Forum Discussion
Post ProdigyLarge Volume of data broken into chunks with multiple API Calls
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
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.
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.
2 Replies
- foodd
Community Champion
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.
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.
