Can't connect to Zendesk tickets table using Power BI Desktop connector

[Anonymous]

Hello,

I receive this error when trying to connect to the Zendesk Tickets table through the connector in Power BI desktop. 

I have used the query editor to limit the number of tickets by date and eliminated unnecessary columns but the query times out after about 45 minutes. I have agent level access currently. Any help would be appreciated. Thanks!

[antonstorozhuk]

Hello @Anonymous 

I'm Anton from Alpha Serve.

In case you're still struggling exporting data from Zendesk, you might want to try out our Zendesk app: Power BI Connector:

• https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/
• https://www.alphaservesp.com/products/zendesk/power-bi/

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Thank you.

Regards,

Anton

[dax]

Hi jwarner, 

You could try to connetc to Zendesk, then open the Edit Queries to filter the data , instead of use parameter in link to see whether it work or not. In addition, I find a similar post of this problem (Power BI Desktop - Zendesk Refresh Error "unprocessable entity") , you could refer to this for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @dax , where can I find the credentials to access Zendesk database? 
I need: 

- server

- database 

- user

- password

bit I don't know where to find them