import data from sp on premise

[Ritaf]

Hi ,

I am trying to import list data from sharepoint on premise an getting atached error :

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (אין אפשרות להשלים את השאילתה מכיוון שמספר עמודות בדיקת המידע שהיא מכילה חורג מסף עמודות בדיקת המידע שמנהל המערכת אכף.)
Details:
DataSourceKind=SharePoint
DataSourcePath=http://portal2013/hr
SPRequestGuid=f2afce9e-6587-2006-4b7d-296776678c30
Url=http://portal2013/hr/_api/Web/Lists(guid'8ff7a864-97b5-46a3-a78e-65a163cb7aa4')/Items

the text on hebrew says that the list have too much columns

it's my third list, 2 imported wothout any difficulties i have a problem with 1 specific list.

please advice,

thanks , 

Rita

[v-yuta-msft · Accepted solution]

@Ritaf ,

This error is caused by invalid URL or invalid credentials. As the error message mentions, please check if the query can be acceptted by sharepoint server and if the number of queries is exceeding the threshold.

Community Support Team _ Jimmy Tao

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

[Ritaf]

Thanks a lot