1 Reply Latest reply: Sep 27, 2017 3:18 PM by Ozzie Boeuf RSS

    Qlik Sense - SharePoint Rest connection pulls only 1000 records

    Sujeet Shirude

      Hi all,

       

      We have connected Qlik Sense 3.2 and SharePoint using Qlik Sense Rest connector but for some reason it limits the load to only 1000 records. Is there a way to pull all the data in the SharePoint list? If yes, how?

       

      Any insights on this are appreciated. Thank you!

       

      Regards,

      Sujeet Shirude

        • Re: Qlik Sense - SharePoint Rest connection pulls only 1000 records
          Ozzie Boeuf

          Hi,

           

          My experience here suggest the following 2 options to look at (assuming you have the appropriate security access):

          • is there a $Top= in your URL?  Consider setting this to the total number of records in your data source to ensure you retrieve all records
          • Open the SharePoint list in question, go to List Tools, select Modify View, expand Item Limit near the bottom of page and check Display all items.  You can also set the number of items shown on a page for that view.

           

           

          SharePoint 2013 List tools.PNG

           

          SharePoint Items Limit.PNG

           

          Beyond that, it is a new area for me too. Hope this works for you.

           

          Cheers,

          Ozzie