I have been playing with the PowerBI Data Connector for Zendesk in both PowerBI.com and using the PowerBI Desktop app.
The canned data set and reports/dashboards are handy as a starting point.
I need to report on 'Total Time Spent on Tickets as per the Time Tracking App' (the total agent/resource minutes spent working on any given ticket, not the time elapsed between logging and resolving the ticket) but that does not appear to be an option with the canned PowerBI integration.
We also need to see Zendesk Custom Fields in PowerBI so that we can easily link with other datasets. We use Custom Fields in Zendesk to store other system unique identifiers.
Can the Microsoft PowerBI.com Connector Default Data Set be changed?
Without this data we are going to have to build our own tables in our Enterprise Data Warehouse which we store in an Azure SQL Server Service (not to be confused with the Azure EDW service) using the Zendesk API.
Is anyone aware of how to get past this limited data set?
Has anyone used the API to populate an EDW? Any tips for someone starting out at this?