Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Getting the full table through API (not just the first 100 rows)

Hey there,   I've connected to Zendesk via Power Bi and I'm facing a problem that my query only brings up 100 rows out of more than 400 available. I've looked into many different topics in Power Bi...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hey buddy, this video helped me to solve this problem

     

    Thanks for your response.


    https://youtu.be/M6q9cSpOD-o

lbendlin's avatar
lbendlin
Super User
3 years ago

See that "next_page"  data point?  You need to follow that until it is no longer there.

 

Read about accessing paginated APIs with Power Query.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey buddy, this video helped me to solve this problem

     

    Thanks for your response.


    https://youtu.be/M6q9cSpOD-o

  • jessica-ko's avatar
    jessica-ko
    Advocate I
    3 years ago

    Please can you elaborate on what you mean to follow it till its not there? thanks for the help.