Forum Discussion
JSON file transformation
Hello I am looking for some help with an API and JSON file transformation. I have searched quite bit but can't find an answer so apologies if this is an obvious one. I have a JSON file which I ...
See if this thread can help you:
https://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823
Looks like your API has a record limit on each call. You will either need to modify the web call to increase the # records returned to >830, if possible. Otherwise, you need to make multiple calls to get all your data. Please see this video for one approach to do that.
Power BI - Tales From The Front - REST APIs - YouTube
Pat