Data reporting - Power BI integration

Modified on Wed, 8 May at 7:52 AM

Available on Asana Enterprise and Enterprise+ tiers, as well as legacy tiers Business and Legacy Enterprise.

Visit our pricing page for more information.

Power BI integration allows Asana users to report on key Asana data from within Power BI.

The Asana Power BI Connector enables Power BI to connect directly to Asana to retrieve data about your tasks in a specified project, team, or portfolio.

Ensure the following is completed before synching data with Power BI:

Standard task details (title, assignee, due date, etc)
Custom fields on tasks
Parent project data
Tags

Subtasks are not supported unless they are multi-homed as a top-level task in another project in the specified team or portfolio

All of this can be shared with other Power BI Asana users within the organization.

Requirements for installation

Make sure you have access to Asana and Power BI Desktop or Power BI Online.

Power BI requirements:

Access to BI Desktop (Windows only) for full customization, dashboard creation, and publishing
Access to Power BI Service (online) to view data with template or published dashboards

If synching data from a team, the team needs to be on an Enterprise or Enterprise+ plan in Asana

How to connect

How to connect from Power BI Desktop:

Open Power BI Desktop
Click Get Data and choose Asana from Online Services
Click Connect
You’ll be prompted to enter a link, choose a valid portfolio, team, or project link
Click OK
You may be prompted to sign in to Asana and grant permission to Power BI to retrieve your data. Please sign in with a user that has access to your data

How to create a dashboard from tasks:

Click the checkbox for Tasks, then click Load.
You may choose to transform the retrieved data before using it to build a dashboard.
Your task data should now be syncing with Power BI. This can take anywhere from a few seconds to 10 minutes, depending on the size of the team or portfolio you specified.
Once the data is loaded, you’ll be able to start creating a dashboard using the available fields on the right.

You can choose to expand the custom field data and pivot the custom field values so that they show up as individual columns in your dataset.

Key features

The Asana Power BI Connector enables Power BI to connect directly to Asana to retrieve data about your tasks and bring that data to life.

Power BI can:

Analyze task load to ensure teams are on track and meet their KPIs
Connect disparate data sets and transform them into a data model
Create charts or graphs to provide visuals of Asana data
Answer questions in real-time through Power BI bespoke reporting that can aid in forecasting

Use cases

Power BI amplifies your business insights and the value of your Asana data. From Power BI visuals to embedded analytics, your team will gain insights, see opportunities and gain a competitive advantage.

For example, suppose a project manager wants to add Asana data to internal BI reporting. In that case, they can add Asana as a data source to Power BI to build more up-to-date reports and tell a story.

When asked to deliver key insights about a team using Asana, a team lead can filter and group data in Power BI to build reports more tailored to the business that spots trends and make data-driven decisions.

How Asana Power BI connector gives perspective to teams:

It can give teams an overview of the business in one dashboard that allows for cross-functional collaboration and ultimately better-informed business decisions.

Visual data

Users can build custom, actionable dashboards based on Asana inputs like custom fields to get real-time insights into projects and workflows.

A portfolio Lead who currently uses a simple spreadsheet to keep track of projects could use the Power BI Asana connector for a more bespoke, visual tracking system of projects.

A project manager can access task custom field data to build reports specific to the company’s needs, using reusable data models moving forward that provide consistency across reporting.

Optimize processes

It's possible to track and analyze progress against team goals to identify project efficiencies and bottlenecks, eliminate roadblocks, and give insights fast.

Create shareable reports

Users can also layer Asana data with insights from other mission-critical business tools to share a complete snapshot of team performance.

A marketing team lead might add Asana as a data source to Power BI on the web to build up-to-date, transparent, comprehensive, and shareable reports in seconds.

You’ll need a Power BI license to view all reports. To build custom measures, you’ll need to use Power BI Desktop. Enter the URL to the Asana team or portfolio you would like to analyze.

Sample dashboard

This example shows how work management data from Asana can provide insight into how your team works.

Use the Asana for Power BI Integration to access Asana, including tasks, custom fields, tags, projects, and more.

Combine Asana data with other datasets to take a holistic approach to your business.

Limitations

The Asana for Power BI integration supports:

Projects with less than 10k tasks