PowerBI and ZenDesk connector (beta)

[creedyp]

I've just started to look at the new connector for PowerBI into Zendesk.

I have an issue with certain fields such as custom fields, which come back as [List].  There does appear to be a way of navigating into that [List] [Record] [Value] through the BI interface itself when looking in the table view, but I can't figure out how to extract that for filtering or display.

As an example the custome field/value I want to extract from the list is the value held by the custom field 'Category'

Has anyone found a PowerBI query way of doing this, perhaps into a custom column?

[Anonymous]

Hi @creedyp 

We've developed the app Power BI Connector https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/ it allows you to connect Zendesk to Power BI in less than 5 minutes.

On our website https://www.alphaservesp.com/products/zendesk/power-bi/ you could open the documentation and find the answer to your question and we have fast/responsive support team at support@alpha-serve.com

Please let us know if you need any assistance.

Daria 

[creedyp]

Does it get around the zendesk api limit of only returning tickets that haven't been archived?

[creedyp · Accepted solution]

Answering my own question for others that may find this thread.

You can go into the Transform screen in PowerBi and add a new column.

The formular is:

= Table.AddColumn(Tickets1, "Category", each Record.Field([custom_fields]{3},"value"))

Where "Category" is the name of the column, and {3} is the index of the custom field you want to extract, which will be different depending on what field you want.

[v-junyant-msft]

Hi @creedyp ,

Thanks for your sharing! I am sure your efforts will lead to solutions for more people facing the same problems!
By the way, since you have solved the problem, please ACCEPT your answer AS A SOLUTION. Then it will be easier for others to find your post and get the solution, thanks!

Best Regards,
Dino Tao