Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connecting to a SharePoint List

HI

 

I'm connecting to a sharepoint list within Excel and plan to use PowerQuery to manupulate some data - When I connect to the list it's only downloading the first 20 records rahter than the entire sharepoint list. 

 

Where would I find the setting to change this?

 

Thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Have you checked whether your login credentials have restrictions on access to data sources?

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous 

      I do have the correct permissions, I'm the site administrator with full control and created the list myself. 

       

      It seems to be pulling in only the default view of 30 items rather than the entire list, I can't see where this setting can be amended. It might be a question for the SharePoint experts rather than Power Query