Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
creedyp
Regular Visitor

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?

 

1 ACCEPTED SOLUTION
creedyp
Regular Visitor

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.

View solution in original post

2 REPLIES 2
creedyp
Regular Visitor

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors