Question
I want to use Microsoft Power BI to create reports and pull data from Zendesk Support. How do I pull data from Support to Power BI?
Answer
Zendesk doesn't have a native integration with Power BI. As a workaround, Microsoft created an integration to pull data from your Support account to Power BI. For more information on how to integrate Power BI with Zendesk Support, see the Microsoft article: Connect to Zendesk with Power BI.
9 Comments
Hi ,
I used the MicroSoft Power BI APP to connect Zendesk. I found that the rows returned in the Tickets table are significantly lower that what exists in the Zendesk Tickets table.
Is this a known issue?
What are the other solutions to extract the complete dataset ? (We need to finally load it for visualizing in PowerBI) .
If you're using the integration mentioned here: Connect to Zendesk with Power BI I would recommend reaching out to Microsoft directly since it looks like this was created by their team.
I hope this helps point you in the right direction!
Thanks, Brett.
The issue itself does not appear to be with the Power BI connector. This issue is documented from MS that Zendesk changed the API limitations and now limits them to 1000 results, if more are returned the API call fails.
Is there any way to increase this limit on the Zendesk side? It went from 200,000 allowed down to 1000 results allowed on Oct 15, 2019. How is only allowing 1K results via API usable?
Hi Brett,
I also have an issue that may be related to Zendesk's API. When I try to pull data from Zendesk I receive following,
Unable to save the customizations to the server. Error returned: 'OLE DB or ODBC Error: [DataSource.Error] Web.Contents could not retrieve the content from 'https://'business name'.zendesk.com/api/v2/search.json?page=11&query=type %3Auser' (422): Unprocessable Entity. The current operation was canceled because another operation in the transaction failed.
Is this also a MS problem or can Zendesk assist here?
regards, Hans Seuters.
Hi - I'm also getting that ODBC Error - Anyone know who to contact?
That error is in fact expected behavior due to the results limit for the Search API that Microsoft is using to retrieve data. To avoid the error for larger datasets, the Power BI connector would need to employ one of the alternative approaches described in the results limit description. I recommend reaching out to the Microsoft team for assistance on that.
Best,
Hi everyone,
It is now possible to export any Zendesk Support data to Power BI using Power BI Connector from Alpha Serve.
Anna
Hi people of the world!
I also recommend Power BI connector - truly useful tool!
Khrystyna
Please sign in to leave a comment.