Forum Discussion

JasonAuburn's avatar
JasonAuburn
Copper Contributor
Sep 29, 2022

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 entire SharePoint list.

 

Where would I find the setting to change this?

Thanks

power bi
sharepoint

1 Reply

  • iamsarah's avatar
    iamsarah
    Brass Contributor
    Nov 28, 2022
    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?

Resources