Forum Discussion
Power BI Desktop - Zendesk Refresh Error "unprocessable entity"
For anyone who ever has this problem too...it's a really simple fix that I'm surprised I didn't see before.
Simply go into Power Bi>Home Tab>Edit Queries
Go to the table that's giving you the problems and just filter a date row to only pull a certain range of data.
For instance, for the tickets table in the Zendesk pack, I am now only pulling tickets "updated_at" after 4/1/17.
And it worked!
I never thought to try this because I thought that filtering the tables only happened after Power BI pulled all of the data, not before.
Cheers!
Hi kerblooy,
You are able to export data from visualizations to Excel or CSV in Power BI Service, for more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/ .
In addition, based on my research, Zendesk Rest API can return JSON format data. You can consider to get Zendesk data via the Rest API, Power BI Desktop can read the JSON file. Start here to learn more about Zendesk Rest API.
Thanks,
Lydia Zhang
For anyone who ever has this problem too...it's a really simple fix that I'm surprised I didn't see before.
Simply go into Power Bi>Home Tab>Edit Queries
Go to the table that's giving you the problems and just filter a date row to only pull a certain range of data.
For instance, for the tickets table in the Zendesk pack, I am now only pulling tickets "updated_at" after 4/1/17.
And it worked!
I never thought to try this because I thought that filtering the tables only happened after Power BI pulled all of the data, not before.
Cheers!
The solution does not work for me as I still hit the pagination error even when I limit the date to a year or the past 30 days. We have a lot of zendesk tickets per day
Same problem here did you found a solution ?
