Pulling Sharepoint list to Qlikview

DirkCtz — Thu, 17 Mar 2022 20:23:32 GMT

Hi

I have a Sharepoint list with 9000 records. If I use any value between 1 and 5000 with RowLimit=n then the list pulls through successfully. But if I leave it at 0 or any value above 5000 then it does not work.

Are there limitations? how can this be overcome?

LOAD
fields,
FROM [https://.sharepoint.com/_vti_bin/owssvr.dll?XMLDATA=0&RowLimit=0&List={XXXXXXXX-7C41-XXXX-XXXX-XXXXXXXXXXXX}] (XmlSimple, Table is [xml/data/row]);

Re: Pulling Sharepoint list to Qlikview

Or — Thu, 17 Mar 2022 20:36:48 GMT

A cursory Google search suggests this is a Microsoft limitation.

https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-items-list-view-threshold-is-5000/td-p/843047

topic Pulling Sharepoint list to Qlikview in App Development

Pulling Sharepoint list to Qlikview

Re: Pulling Sharepoint list to Qlikview