Asana column missed when importing data into Power BI

[rachelbi]

Hi there, I would like to import Asana data into power bi. However, one of the important piece of record (i.e. Estimated time) is missed after data import, any advice would be appreciated.

The asana list ... which I guess I am right to use this url ? 

Both estimated time and actual time column are needed, but only the latter is captured.

Thank you.

[v-zhengdxu-msft]

Hi @rachelbi 

Confirm that the correct data types have been applied to each column in Power BI Desktop. Mismatched data types can lead to missing data. In Power Query Editor, explicitly query the SQL Server data source for the missing columns. You can do this by typing in an SQL query to retrieve the specific columns you need.

Here for your reference:

Solved: Missing Data - Microsoft Fabric Community

Solved: Re: Excel import - Columns missing data - Microsoft Fabric Community

Here's the link about how to connect to asana:

Power BI integration – Asana Help Center

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.