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.
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