Incomplete loarding data after importing dataset

Hi dofrancis3​,

The message in your screenshot does not necessarily mean that the imported dataset is missing rows.

What Power Query is telling you is that the filter dropdown has reached its preview limit for distinct values. Your second screenshot confirms this with the message:

Limit of 1000 values reached.

So the dropdown is only showing part of the distinct values available in that column. The remaining values can still exist in the underlying table even though they are not listed in the filter menu.

I would verify this by checking the actual row count and distinct count rather than relying on the dropdown list.

For example, in Power Query you can temporarily create a reference query and use:

Table.RowCount(Source)

or for a specific column:

List.Count(List.Distinct(Source[Record ID]))

If those counts match what you expect from the source, then the data has loaded correctly and the warning only relates to the filter-value preview.

You can also use Text Filters, Number Filters, or the search box to filter for a value that is not currently visible in the dropdown instead of scrolling through the list.

So I would first confirm the row count before changing the import logic. Based on the screenshots, this looks much more like a filter-list display limit than incomplete dataset loading.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.