Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Desktop Zendesk (beta) querying more data than a published dataset

Hey, 

So I've connected Zendesk to Power BI desktop and it seems to give me all historic data, but as soon as I publish it to the web the published dataset is unable to reach more than the last 120 days it seems.

 

What gives?

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey,

     

    So I've connected Zendesk to Power BI desktop and it seems to give me all historic data, but as soon as I publish it to the web the published dataset is unable to reach more than the last 120 days it seems.

     

    What gives?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Do you get different results in Power BI Desktop report and Power BI Service report which you publish from Power BI Desktop? Based on this article, Zendesk automatically archives tickets 120 days after they are marked Closed. This limitation comes from Zendesk but not from Power BI.

    There is also a similar thread for your reference.
    http://community.powerbi.com/t5/Integrations-with-Files-and/Zendesk-Ticket-Limitation/td-p/8696

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Yes, there is different results as described. I contacted Zendesk and they told me Microsoft has to look at it.

       

      It makes no sense that I'm able to query all data including archived in desktop, but not on a published dataset.

       

      Please look into it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        Do you apply any filters in the report in Power BI Service after you publish PBIX file from Power BI Desktop to Power BI Service? Could you please post screenshots about report in Desktop and Service?

        Regards,
        Lydia