Pulling Sharepoint list to Qlikview

[DirkCtz]

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]);

[Or]

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...