Zendesk Connector - Multi-select fields display no values

[bradystone]

Using the Zendesk to PowerBi Connector, we're experiencing an issue related to only “multi-select” fields.

In PowerBi, we used a pivot table to display our custom fields and data.  This is working well, with the exception of multi-select fields, whose data does not show up in PowerBi.  The column is present for multi-select fields in the table but not the data; not nulls, just blank cells. 

Has anyone else experienced this issue or found a way to fix it?  We don't have the option of excluding multi-selects, at this point.  

[Anonymous · Accepted solution]

Hi @bradystone ,

If the multi-select fields are coming in as lists or arrays, you can use Power Query to split these into individual rows or columns. Alternatively, you can use the `Expand` or `Add Custom Column` feature to achieve this.

= Table.AddColumn(Tickets, "MultiSelectField", each Text.Combine(List.Transform([custom_fields], each Record.Field(_, "value")), ", "))

If the data is loaded into Power BI but not displaying correctly, you can use DAX to create calculated columns that handle the multi-select fields. For example, you can use the `CONCATENATEX` function in DAX to combine the values in the multi-select field into a single string.

If the connector is not working as expected, you might consider using Zendesk's API to pull the data directly into Power BI. You can use Power BI's `Web.Contents` function to call the Zendesk API and retrieve the data, then transform it as needed in Power Query.

If this still doesn't solve your problem, I recommend contacting Zendesk's support team at support@alpha-serve.com. 

Power BI Connector for Zendesk | Zendesk Power BI Integration App by Alpha Serve

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.