Asana to PowerBI | Missing Fields/Columns

[Ahmed_R]

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 fields and project custom fields within powerquery but unable to find this particular field. I need your expert advice on how to get this missing column in PowerBI which is available in Asana. Does anyone know why is this happening and how can we resolve this?

Thank you for your help.

[mdHuz]

Hi

Those custom fields which doesn't have any data for any associated task or project are not visible in the Power BI.
If you want these custom fields in Power BI, some value has to be added for that particular field in Asana.

Please try this and let me know if this works out for you.

[Ahmed_R]

Thank you for your response. I have already tried all of the above mentioned and ensured the integration protocols are intact. I can access 4 out of 5 custom fields already in powerbi, it's just one particular field that doesn't show up. The field is in the same project list in Asana. I will be grateful if you could guide me on this specific scenario.

[Anonymous]

Hi @Ahmed_R ,

Thanks for your reply. So there is only one "specific" custom field can't be loaded into Power BI. Is that custom field can display in Asana? Is it different from the other 4 custom fields?

Best Regards

[Anonymous]

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