Forum Discussion
PowerBI and ZenDesk connector (beta)
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?
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.
4 Replies
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.
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
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 [email protected]
Please let us know if you need any assistance.
Daria
Does it get around the zendesk api limit of only returning tickets that haven't been archived?
