Forum Discussion

kerblooy's avatar
kerblooy
Frequent Visitor
9 years ago
Solved

Power BI Desktop - Zendesk Refresh Error "unprocessable entity"

Hello!   I use Power BI desktop to monitor Zendesk stats.   I missed a couple days of refreshing the data (darn you manual refresh...)   And now when I refresh the refresh cancels out on the "T...
  • kerblooy's avatar
    kerblooy
    9 years ago

    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!