Load Asana custom fields via Power BI API

Integrations
#1

Hej all,
we have a requirement to show some asana-data in our powerbi.
I tried the default asana-api in Power BI and it works except i dont get the custom fields from our asana.
So i was searching for a solution for that named problem and found this forum.
Most of the post are older then one year and i found no “easy” way to get those custom fields outside of asana with power bi. I read with some third party application i can realise named problem.
But, on the asana-page about Power BI itself i read that it is no problem to get access to the Power BI Custom-Fields, so what am i missing here?
Quote(https://asana.com/apps/powerbi): " Visualize your team’s work
Build custom, actionable dashboards based on Asana inputs like Custom Fields to get real-time insights into projects and workflows."

So is there at the moment an “easy” solution for loading custom fields into Power BI? or is coding/a third party necessary?

Thanks for the help!
Greetings
Mischa

1 Like
#2

Hi Mischa,

First, I saw it’s your first time on the forums, welcome!

I just did this in Power BI, when I’m back in front of my work computer I’ll let you know! I’ll toss the steps I took into this thread :smile:

But I do remember it was a lot of intermediary steps…

Cheers!

#3

I’m looking for the same thing!

Currently in Power Query Editor but the custom fields I have created are not expanding with the values I expected.

#4

Hej Will!
can you please give us an update? : D

I am one step further but still not at the finish line.
I get the data now, but in a total messed up way.
It looks like, that i get for every Custom field, every value from every custome field of the task.
That means what was once one dataset become five, because i have my five custome fields.
Looks like that:
image
Just the green marked one is the correct value for the field “Responsible”, every other value comes from another custome field i have.

Thanks for the help.

Greetings
Mischa

#5

I think I’m having the same issue on this - I’m unable to load custom fields from Asana into PowerBI through the direct link. I can load them with a CSV

#6

I’m also with the same problem. We use a few custom fields to control our projects and I need to create a dashboard on Power B.I. Really looking foward for this solution.