Import SharePoint List with Calculated Columns

[Anonymous]

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?

[v-shex-msft]

HI @Anonymous,

Which version of sharepoint site you used? Online or on-premise? Can you ensure you have permission to access that list and use the correct credentials on power bi desktop side?

Please share more detail information to help use clarify this issue.

Regards,

Xiaoxin Sheng

[Anonymous]

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.

[v-shex-msft · Accepted solution]

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