Forum Discussion
Creating Loop in Power Query and API
Hi, I'm connecting to an API which have a 500 row limit. There are separate columns in the returned json that states how many rows there are in the current search, and how many there are in total...
Please see this video. It walks through how to do this by first creating a list of numbers/offsets.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeePlease see this video. It walks through how to do this by first creating a list of numbers/offsets.
Power BI - Tales From The Front - REST APIs - YouTube
Pat