Forum Discussion
Import SharePoint List with Calculated Columns
I am experiencing an issue where I cannot import one of the lists from a SharePoint site. The error I receive is below.
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)
Details:
DataSourceKind=SharePoint
DataSourcePath=http://MySiteName
SPRequestGuid= a SharePoint guid
Url=http://MySiteName/subsite/_vti_bin/ListData.svc/ListName
From my internet sleuthing, I beieve it is due to the list having calculated columns. Is anyone else having this problem? If so, were you able to get past the issue?
Hi Anonymous,
So you want to get custom fields from on-premise sharepoint site, right?
If this is a case, current sharepoint connector seems not work for custom fields, please use rest api to get data from sharepoint site.
Working with folders and files with REST
Regards,
Xiaoxin Sheng
3 Replies
Thanks for the response. Sharepoint is on-prem not cloud. I was given rigths to it by the admin and I can view the list through my browser. I am using my AD credentials in browser and Power BI. I can view other lists, but not this one. The only difference I see is that the list i cannot connect to has calculated columns.
Hi Anonymous,
So you want to get custom fields from on-premise sharepoint site, right?
If this is a case, current sharepoint connector seems not work for custom fields, please use rest api to get data from sharepoint site.
Working with folders and files with REST
Regards,
Xiaoxin Sheng