Forum Discussion
PowerBI and ZenDesk connector (beta)
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
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?