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 transform and I have 830 records.
When I convert to a table, there are only 30 records. This happens with various other parameters on the same API, always limiting to 30. I feel like the API works but the transformation step is somehow limiting the records.
any help gratefully received.
See if this thread can help you:
https://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823
3 Replies
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
See if this thread can help you:
https://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823
