Missing data rows

[HXM001]

While getting data from a SharePoint list I notice that multiple rows of data were missing in Power Query.

I refreshed the data and compared what was in Power Query with what was on the SharePoint list but I am still missing rows of data.

Is there something else that needs to be applied to get all the information visible?

[HXM001 · Accepted solution]

Nevermind. It was a very simple solution. I didn't realize that the table sorted by ID and not Title. The rows that I thougth were missing were just further down the table.

Thank you for the help!🙃

[jennratten]

Without any other information or screenshots to go on, it's really hard to say, but you should check to be sure you are querying the entire list as opposed to a view of a list.