DataSource.Error with zendesk

Hi,

The Zendesk Team decided to reduce the number of tickets you can request from 200k to 1k.

PowerBI's Zendesk plugin tries to fetch all the tickets and it fails. You get 10 pages of tickets in return with 100 tickets each. Hence the error when you get to page 11 (which is not allowed to request anymore).

If you're happy with a set of 1000 tickets for each search criteria you set, you can do the follow:

1. In your PowerBI application add a new Data Source of type Web.

1.1. URL: Paste in https://your_url.zendesk.com/api/v2/search.json?page=1&query=tags%3my_tag_1&sort_by=created_at&sort_order=desc

You can decode this URL to see how it is built, according to Zendesk API documentation. You can also add multiple tags which gives you an OR operation. You could also use * at the end of a tag which gives you a 'begins with' criteria. The options are many.

1.2 URL PARAMETER

Add a parameter of type Authorization with the value 'Basic email_address:password'.

The email_adress:password part must be BASE64 encoded. If you have Powershell, paste in 

$b = [System.Text.Encoding]::UTF8.GetBytes("email:password")
[System.Convert]::ToBase64String($b) 

2

Go to the PowerBI Queriy editor and duplicate your query nine times. In the right pane, for the 2nd to the 10th query, select the wheel on 'Source' step and edit the URL page param no to 2, 3, 4 and so on. Please see the blue colored text in step 1.

3. On the ribbon in the PowerBI Query Editor choose 'Merge' or 'Concat' and select all the 10 queries.

You will now how a working solution filtered on your custom query.