JSON file transformation

[Anonymous]

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.

[V-lianl-msft · Accepted solution]

See if this thread can help you:

https://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823 

[Anonymous]

Thanks Pat, i will invesitgate

[mahoneypat]

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