I am Trying to connect SharePoint list to Qlik using Qlik's SharePoint Metadata connector.
-
As there are multiple view present in the SharePoint list, I want to retrieve data from particular view
-
while previewing data from a particular view, I am getting a "Internal Server error" with error code 500.
-
One possible reason might be number of columns as these two view have too many columns(>50) and records(>20k), but I am able to retrieve data from other views where number of columns are significantly less.
-
I tried manually to retrieve 2 columns with 10 record using script but the error remains the same.
I am not sure whether number of fields is an issue here, as the connector is not allowing to connect with the SharePoint list with particular view.