Hey @Mark_Hudson,
Thanks for reaching out. Microsoft built the Asana BI content pack and unfortunately it does not include custom fields data. I suggest that you reach out to BI support and ask that they add custom fields to the Asana content pack. I will also ask our contacts at BI to see if they can add this feature.
In the meantime, you could import your own data source to BI instead of using the pre-built Asana content pack. Depending on your requirements, this might require some development work on your end.
Here are a few options of what you could do to get BI reports that include custom fields (and any other Asana data you want to include):
- Export your Asana project to CSV and then upload the CSV to Power BI (no coding required, but a bit manual)
- Write a script that gets your Asana data via the Asana API, then upload it to BI
- Use our Asana2SQL Python script to export your data to SQL, then upload to BI
For your reference, here is an article that outlines the data source options for Power BI.
I hope that helps. Let me know if you have any other questions. Also, please share if you end up building anything.
Cheers!
Jeff