Power BI Desktop and Asana

Hello there!, How do I connect my power bi desktop app to my asana account for advance reporting?

Thank you.

2 Likes

Hi @PedroPablo_Leon

Unfortunately, I don’t think it’s possible to connect the desktop app directly to Asana. I couldn’t even connect mine to the dashboard Google Sheets report. However, there is an Asana app for Power BI online. Unfortunately, it doesn’t include custom fields, but you can report on tasks, due dates, assignees, etc. It’s worth checking out if you haven’t already tried it.

HI @PedroPablo_Leon

This is the link you need:

One of my clients connected Power BI with Asana. So if you have specific questions I can forward them. He is not active in the Asana Community yet, but a great reason to join if the two of you can excahnge about Asana Power BI hacks :slight_smile:

Always great to meet people mastering the same challenges

1 Like

Hey @Sebastian_Paasch

I would also love to link the Power BI desktop app directly to Asana, if your client knows a way to do it. The integration is very good, but without custom fields I can’t report on most of the milestones my manager wants. At the moment, I have to export everything from Asana, then use the CSV to create a Power BI report. It would be so much easier to have a direct link.

Thanks

7 Likes

I tried the Power BI integration. I logged into the online Power BI and then selected Get Data | Services (Get) | searched for Asana | Get It Now. To connect to Asana it asked for my “workspaceName” and “teamName”. I am an Asana noob here. What is my workspaceName in Asana? I tried a few things and none of them worked

I get a Power BI error “The key didn’t match any rows in the table”

Any updates on this from any of you?

Would workspaceName = Project name you want to report on and teamName = Team that the project is sitting in?

Hi @Troy_Hudson I had the same issue. So to sync Asana with Power PI, you need to copy the exact workspace name that you find on top of your screen. It should say something like “My task in ”. It’s not the name of the project.

You can also find workspace name by clicking on your user icon in the upper right corner of your screen. There should be a check mark by the workspace that you are currently reviewing.

And the team name should be listed under “Reports” on the side menu. This name also need to be copied over exactly as is when linking Power BI with Asana. Otherwise it will generate an error.

3 Likes

What is the fastest/simplest way you’ve found to figure out how to run a report in Power Bi from things you want to see from Asana? any good simple tutorials out there?

I’m having a similar issue. We converted our workspace to an organization and I haven’t been able to connect. I didn’t get a chance to try connecting before the conversion, so I don’t know if the issue is because the connector requires a workspace or if I’m doing something wrong. Anyone out there who has converted their workspace to an organization still able to connect with Power BI?

Hello, I searched but apparently there are no up to date topics about this.

Is there anyway to connect my Power BI dashboards to my projects?

I tried and got to work an integration but only to visualiza Asana Data in power BI, but I actually wanted my teams to see my reports in our project.

Thanks

Did you see this discussion?

Thanks @Bastien_Siebman! Merging this thread with Power BI Desktop and Asana - #2 by Mark_Hudson to avoid duplicates!

@Fabio_De_Souza_Olive, welcome to the Forum and have a look at the posts above! Let us know if you have any follow-up questions!

there is only one problem, its not the same question you see

I was looking for any integration and not only with the desktop power BI

could you unmerge please?

I’ve done so much research on this and the best and cheapest way to do it is to head over to Fiverr and find a .PHP or Python coder to drop the export info into a .CSV for your Power BI to do it’s thing.

Don’t use Google sheets, it max’s out at so many lines. I think it’s 250 lines…

Don’t look for a plug in as they are dearer than poisen.

And whatever you do, don’t use the useless Power BI plug in because it’s useless. I think I did useless twice… Now three…

1 Like

Hi
is the Power BI integration still available?
I was unable to find it from the integration store.
Regards
@Sebastien_Levesque

Hey @Sebastien_Levesque,

It seems it’s no longer available; see here for details:

It was practically useless anyway, Without custom fields it was a tease.

Parece que ya no se integran… tienen otra aplicación para visualizar data?

Export search reports to CVS then import to Bower BI. Save to the same place to over ride old file with latest data and have PowerBi automatically update upon open?

[quote=“Sebastian_Paasch, post:3, topic:15710”]
One of my clients connected Power BI with Asana. So if you have specific questions I can forward them. He is not active in the Asana Community yet, but a great reason to join if the two of you can excahnge about Asana Power BI hacks :slight_smile:

Always great to meet people mastering the same challenges
[/quote]It is disabled, there is another way to connect Asana to Power BI