Incomplete loarding data after importing dataset

“List may be incomplete” refers to the filter dropdown. Power Query initially lists up to 1,000 distinct values there. That warning alone doesn’t indicate that rows were skipped during import.

Pick one project that’s missing from the report. In Power Query, use Text Filters > Equals and type its exact name. This lets you check for it even if it isn’t listed in the dropdown. Remove that temporary filter after testing.

If the project is missing from the final Power Query step, check whether it exists at the first step that shows your data, then look for the step where it disappears. If it’s present in Power Query and in Table View after Close & Apply, check the report filters and the relationship used by the visual.