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!
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 ?
