Forum Discussion
Connecting to a SharePoint List - Not all data retrieved
HI I'm connecting to a SharePoint list within Excel and plan to use PowerQuery to manipulate some data - When I connect to the list it's only downloading the first 20 records rather than the entir...
The only thing I can think of is your table might have relationship with another table.
In Excel check Data > Relationships or PivotTable>Relationships and make sure your table is not related to another table.
If it's not related, in SharePoint can you check the list default view and make sure there is no filter on the view and you're able to view all records?
In Excel check Data > Relationships or PivotTable>Relationships and make sure your table is not related to another table.
If it's not related, in SharePoint can you check the list default view and make sure there is no filter on the view and you're able to view all records?