Incomplete loarding data after importing dataset

dofrancis3​ ,

The "List may be incomplete" warning doesn't mean your data failed to load. Power Query builds that filter list from a preview of the first 1,000 rows only. When you click Close & Apply, all rows are loaded.

If you need the full list in the filter box: click Load more in the dropdown, which appears next to the warning. You can also set the status bar at the bottom to "Column profiling based on entire data set".

If data is really missing in the report, check these:

1. Filters you applied by accident. In your first screenshot, Indicator Logframe Entity has unchecked items, so a filter step is removing those rows. Look in Applied Steps for a "Filtered Rows" step and delete it or correct it.
2. Rows with errors. A data type change, such as text converted to a number or date, can create errors. Check for a "Removed Errors" step, and look for red bars in View → Column quality.
3. Relationships. If key values don't match between tables, for example because of extra spaces or different text case, visuals show blanks or drop rows. Use Trim and Clean on key columns and check the relationship.
4. Visual or page filters. Check the Filters pane in the report.
5. Check the counts. In Table view, compare the row count shown at the bottom with the row count in the source file. If they match, all data was loaded, and the problem is filters or relationships.