Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

0

Zendesk api not working

Submitted by Anonymous on ‎07-11-2022 03:49 PM

Hi all,

 

I have been trying to connect the Zendesk api to Power BI, but i get this error message: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://mindbridge.zendesk.com/api/v2/search.json?page=11&query=type%3Aticket' (422): Unprocessable Entity. '

 

is there any way to rectify this? 🙂

Status: Delivered

Hi @Anonymous ,

 

To connect to Zendesk, please make sure your proper Zendesk URL and a Zendesk adminstrtor account. For more details about the requirements, you could refer to Connect to Zendesk with Power BI - Power BI | Microsoft Docs.

 

In addition, there are some limitations on this api/connector. Before Oct 15, 2019, the Zendesk Support Search API allowed for a total of 200,000 results to be received through pagination of large queries. To align search usage with its intended scope, Zendesk now limits the maximum number of results returned to 1,000 total results, with a maximum of 100 results per page. However, the current Power BI Zendesk connector can still create API calls that exceed these new limits, resulting in possibly misleading results. Zendesk will return a 422 error status if the instance returns more than 1000 rows. For more details, you could refer to Power Query Zendesk (Beta) connector - Power Query | Microsoft Docs.

 

Here is a similar issue: Solved: Power BI Desktop - Zendesk Refresh Error "unproces... - Microsoft Power BI Community. You could reduce the data fetched as the solution mentioned.

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
1 Comment (1 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎07-11-2022 07:20 PM
Status changed to: Delivered

Hi @Anonymous ,

 

To connect to Zendesk, please make sure your proper Zendesk URL and a Zendesk adminstrtor account. For more details about the requirements, you could refer to Connect to Zendesk with Power BI - Power BI | Microsoft Docs.

 

In addition, there are some limitations on this api/connector. Before Oct 15, 2019, the Zendesk Support Search API allowed for a total of 200,000 results to be received through pagination of large queries. To align search usage with its intended scope, Zendesk now limits the maximum number of results returned to 1,000 total results, with a maximum of 100 results per page. However, the current Power BI Zendesk connector can still create API calls that exceed these new limits, resulting in possibly misleading results. Zendesk will return a 422 error status if the instance returns more than 1000 rows. For more details, you could refer to Power Query Zendesk (Beta) connector - Power Query | Microsoft Docs.

 

Here is a similar issue: Solved: Power BI Desktop - Zendesk Refresh Error "unproces... - Microsoft Power BI Community. You could reduce the data fetched as the solution mentioned.

 

Best Regards,

Community Support Team _ Caiyun

Idea Statuses