Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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!🙃
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!🙃
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.