Forum Discussion
DataSource.Error connecting to SharePoint 2010 list
This failure when trying to connect to a list on SharePoint. The list has a variety of field types, like People, Choice, and Multi-Line text fields.
DataSource.Error: We couldn't parse OData response result. Error: An error was read from the payload. See the 'Error' property for more details.
Details:
DataSourceKind=SharePoint
DataSourcePath=http://teamsharepoint/sites/teamsite/_vti_bin/ListData.svc/Upgrades
Please help, I need to connect this list to PowerBI.
I was having this same issue on two particular lists on our SharePoint 2010 site. I read some posts that mentioned it could be caused by lookup fields, but neither problem list had such fields. Other posts mentioned people/person fields, I had them but I ruled that out as well.
So I turned to the calculated columns in my list. I had three. I set each one to just a calculation of "=1" and saved, and noted that the ListData.vsc started working! While two of the calculated fields had much more advanced formulas, after process of elimination I determined that this calculated field is the one causing the problem for me:
Field Name: "Expected Launch Date" Field Formula: =IF([Call 2 Completed]=0,"TBD",[Call 2 Completed]+7) Return Type: Date Only
You might see the problem now -- my simple "IF" formula is returning text "TBD" string for a column with a type that must return "Date Only". So, I changed the formula to the following and my list is still working now.
New Formula: =IF([Call 2 Completed]="","",[Call 2 Completed]+7)
Read as "If [Call 2 Completed] is null, use null. Otherwise, add 7 days to [Call 2 Completed]"
Anyway I think I'm good now.
1 Reply
I was having this same issue on two particular lists on our SharePoint 2010 site. I read some posts that mentioned it could be caused by lookup fields, but neither problem list had such fields. Other posts mentioned people/person fields, I had them but I ruled that out as well.
So I turned to the calculated columns in my list. I had three. I set each one to just a calculation of "=1" and saved, and noted that the ListData.vsc started working! While two of the calculated fields had much more advanced formulas, after process of elimination I determined that this calculated field is the one causing the problem for me:
Field Name: "Expected Launch Date" Field Formula: =IF([Call 2 Completed]=0,"TBD",[Call 2 Completed]+7) Return Type: Date Only
You might see the problem now -- my simple "IF" formula is returning text "TBD" string for a column with a type that must return "Date Only". So, I changed the formula to the following and my list is still working now.
New Formula: =IF([Call 2 Completed]="","",[Call 2 Completed]+7)
Read as "If [Call 2 Completed] is null, use null. Otherwise, add 7 days to [Call 2 Completed]"
Anyway I think I'm good now.