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?
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.
Darina Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen
Darina Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen
Thank you for your reply anyway, Darina.
I am connecting Power BI with Wrike connector and facing same issue.
do we have a solution for this now ?
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.
Rohan V Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen
Rohan V Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen