We are working on multiple projects with Asana and wanted to have insights over some project and task management KPIs within Power BI. There is a dedicated connector within Power BI to integrate data from Asana. However, the licensing requirements to use the connector are the enterprise or enterprise+ tiers. We had a look around to find alternatives but didn’t find anything satisfactory – so we built our own. Via the Asana API the data can be extracted to Power BI even with a Free Asana License.
And the best part is we are making the report available for free. You can request the Power BI Report by mail below. Send us the email and you will receive the report template:
Setup & Requirements
What you need to set up the report with your own Asana data:
- Power BI Desktop
- Your Asana API token from the developer console
- Your Asana workspace gid
- The report template
Open the .pbit file with Power BI Desktop and add the token and your workspace gid. Have a look at the videos below to get a step by step instruction. The report is provided as-is, but can be customized. Reach out to us directly if you need additional metrics or a tailored experience.