I get the error as well, trying to import to Power BI (Online) from Zendesk using the content pack.
------------------------------------------------------------------------------------------------------------------
"If you can connect and refresh the data successfully in Power BI Desktop but still fail in Power BI Service"
Confirmed. I can indeed connect and refresh the data in Desktop but unable to successfully load the ticket data (I guess there is just too much and will take hours for it to sync via the Zendesk API). I will attempt to run a Fiddler trace.
Power BI Desktop connected to Zendesk:
If I click 'close and apply' it goes no further than:
(I glimpsed ' creating connection model' for a second before this as well)
------------------------------------------------------------------------------------------------------------------
There appear to be successful Zendesk API calls as this nr is incrementing steadily:
------------------------------------------------------------------------------------------------------------------
My ultimate aim is to be able to produce interactive Zendesk reports that end users can drill down to and view the relevant ticket descriptions to their context.
The next aim is to do semantic analysis of the ticket descriptions (have already done successful tests on the data by piping it to MS Social Engagment via RSS but this might work better in Azure I think.. after watching one of Josh Caplan's videos)