Forum Discussion
Asana column missed when importing data into Power BI
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.
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.
1 Reply
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.