Excel Power Query to get all custom fields in separate columns, not rows

Hi,

I am experimenting with Excel Power Query and the Wrike API. I am very impressed, it works really nice. The only thing I failed to do is to get custom fields into separate columns, not rows. With my current query, Excel generates me a row per custom field, so I get a lot of redundant data in my Excel sheet.

I want to have only a single row per Wrike task and one column per custom field. But I could not figure out how to correctly expand the data record.

Could you please take me by the hand?

Find more posts tagged with

Comments

Darina Fišer

Hi @Stefan Jung , thanks for reaching out!

It looks like your question focuses on Excel rather than Wrike API, and I am afraid we don't have the info on that. So I could totally recommend checking it with Microsoft Support on how to expand the data record.

Let us know if there's anything else we could assist you with.

Stefan Jung

Thank you for your reply anyway, Darina.

Mohd Imroz

I am connecting Power BI with Wrike connector and facing same issue.
do we have a solution for this now ?

Rohan V

Hi @Mohd Imroz 👋 Welcome to the Community Forums! I see that you are already in touch with our support team. Please let me know if your issue has been resolved; if not, I can raise another support ticket on your behalf.

Nathalie Lapierre

I'm testing with Power BI and Wrike connector and have the same questions. If there is a solution, I'd like to get details.

Rohan V

Thanks for reaching out @Nathalie Lapierre. Our Support Team can assist with your query. Please feel free to raise a support ticket by clicking here. Thank you 🙂