55 votesDaniel Shapiro commented
Fundamentally there seems to be a disconnect between the way Zendesk intends for its latest API to be used and the way that Power BI works (AFAIK).
Zendesk now says that their "Incremental API" should be used for reporting in BI tools:
- See the table at the top of this page: https://develop.zendesk.com/hc/en-us/articles/360022563994
- See this comment by Zendesk dev support: https://develop.zendesk.com/hc/en-us/articles/360022563994/comments/360003446454
But the usage notes for the Incremental API say "You shouldn't use this API to repeatedly export complete lists of items.", and my understanding of how basic Power BI queries/data sources work is that they require exactly that.
The Incremental API also has a rate limit of 10 requests per minute, with a maximum of 1000 results per request, so there's effectively a limit of 10K results on anything that Power BI service would be able to refresh: https://developer.zendesk.com/rest_api/docs/support/incremental_export#usage-notesDaniel Shapiro supported this idea ·