Zendesk and PowerBI

Is there a dataset available to link Power BI to Zendesk?

Hey Don!

I'm not sure exactly what you'd need for this, but have you checked out our API documentation?

Yes, you can either use the default connector provided by Microsoft Power BI or you can try our custom connector available on our public GitHub Page.

Our custom connector is extremely useful to fetch Zendesk Support views and tickets information from Zendesk. The connector uses OAuth 2.0 to access your Zendesk's account data.

https://github.com/ranmax123/powerbi-custom-connectors#the-zendesk-support-tickets-connector

There is a Zendesk data source still in beta, once you have connected to that I would do all the filtering in the "Edit Query" section of Power BI. If you click on Advanced editor you could use this as a starting point:

let
    Source = Zendesk.Tables("https://SUBDOMAIN.zendesk.com"),
    tickets = Source{[Key="tickets"]}[Data],
    #"Filtered Rows" = Table.SelectRows(tickets, each Date.IsInCurrentDay([created_at])),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"status", Order.Ascending}, {"priority", Order.Ascending}})
in
    #"Sorted Rows"

This should grab everything created Today and sort them by status and priority. 

where can I find the channels tickets are created from in the tables?

Hi Brett, 

I can't follow your link to GitHub (I get redirected to Zendesk's support center).

Do you have a new link? I'm facing the same trouble to connect Zendesk to PowerBI.

Thanks, 

https://github.com/ranmax123/powerbi-custom-connectors#the-zendesk-support-tickets-connector

or you could just type it :D

Hi Brett,

we are currently using the zendesk APP for Power BI.

There are a lot of measures available. Is there any kind of documentation, what is the exact meaning of the measure?

For Example: Avg. First Resolution Time or Avg. Reply Time?

Thanks a lot

Andy

Hi!

What's the pro's and con's by using Microsofts PowerBI connector vs using Zendesks?

Is there any difference?