Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I woul like to know what is the root cause for the error when power BI can not get contents from Zendesk.
I can view the preview table and even modify the information in the Query editor; when filter some of the information in order to see just a couple of rows, appears an entire row with the "Error" word in each column. The message show when i tried to use a table with this error is:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://pedidossq.zendesk.com/api/v2/search.json?page=11&query=type%3Aticket' (422): Unprocessable Entity. '.
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.
Thanks for this feedback, saved me a bucket load of time trouble shooting when I received similar issue this morning.
hi @Anonymous
It seems that Zendesk has chance their API Recently:
If you only have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.
Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |