Forum Discussion
API returning only 1000 results
I'm using the SDMX API to call up census data, and there are 1600+ rows, but Power BI is only importing 1000. This is the API: http://api.statcan.gc.ca/census-recensement/profile/sdmx/rest/dat...
Hi bonjourposte,
I'd like to suggest you take a look at the following official document link with some helper functions to know how to handle pagination API:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng
Thanks, I contacted SDMX, and they said there is no page 2. The entire data WAS loading into Power BI, but I couldn't get it out into Excel. I eventually just manually merged every Code ID in a matrix visual, clicked the three dots, and exported to csv.
