Forum Discussion

Ahmed_R's avatar
Ahmed_R
New Member
2 years ago

Asana to PowerBI | Missing Fields/Columns

Hello,   I am trying to connect Asana to PowerBI. I am using the Asana connector available in PowerBI. All other fields are shown except one custom field in powerbi. I have expanded on the custom f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ahmed_R ,

Base on your description, it seems like the custom field can't be shown when connect to Asana in Power BI Desktop. Could you please check and confirm the following info?

  • Check if the custom field has been  exists in Asana and is correctly added to the relevant tasks or projects.
  • Make sure that the Asana API token or integration has the necessary permissions to access the custom fields. 

 

In addition, you can refer the following post and check if the provided method can help you resolve the problem.

Load Asana custom fields via Power BI API - English Forum / Integrations - Asana Forum

I’m going to get a bit technical but I’m not a super duper power BI developer, I’m a poke around until it works developer. 

  1. Under Transform data, you will want to add asana as a data source with a project or portfolio URL
  2. Save that table, I really don’t do any manipulation, that’s a list of all tasks, by task ID.
  3. Copy and paste that query.
  4. Click the branching arrows at the top of the custom fields column, select Expand to new Rows
  5. Values showing List now say “Record”
  6. Click the branching arrows at the top of the custom fields column again, this time you get a small window of what to select, I leave all checked. and press OK.
  7. I deleted Custom Fields.id, Custom Fields.project_id and Custom Fields.Type, those aren’t relevant for me.
  8. I’m left with 2 new columns, custom fields.name and custom fields.value.
  9. I delete everything except task ID, custom fields.name and custom fields.value.
  10. Some of my fields showed up at “Field Name - Project” so I split column by delimiter of ‘-’ and deleted Custom Field name.2
  11. I filtered custom fields.name.1 to exclude nulls.
  12. Select Custom fields.name.1, and select pivot column under transform ribbon. Select Custom Fields.value, then under Advanced options select don’t aggregate.

End results is a list of Task ID, and a column with each custom field and its value. I then just make a relationship between task ID of the custom field table and the tasks table.

Solved: Asana column missed when importing data into Power... - Microsoft Fabric Community

Best Regards