Solved: JSON file transformation

Anonymous · ‎07-06-2021

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 · ‎07-07-2021

See if this thread can help you:

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

View solution in original post

V-lianl-msft · ‎07-07-2021

See if this thread can help you:

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

Anonymous · ‎07-06-2021

Thanks Pat, i will invesitgate

mahoneypat · ‎07-06-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube