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