Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

SharePointAU

DataSource.Error: We couldn't parse OData response result. On-Premise SP 2013 List

Submitted by on ‎05-25-2018 08:31 AM

I'm having an issue where I am connecting to an on-prem SharePoint list, and get an error about being unable to parse data. This strange thing is I'm using several other lists from the same farm with not issues. 

 

What would cause this, and how can I troubleshoot it? 

 

Capture.PNG

Status: Investigating
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎05-28-2018 02:07 AM

@SharePointAU,


Do you use "SharePoint List" connector in Power BI Desktop? If so, what is the result when you use OData feed connector to connect to this specific list in Power BI Desktop? You can use the following OData URL.

https://yoursharepointsite/_vti_bin/listdata.svc/ListName

In addition, please clear cache in Power BI Desktop. And check if there are any difference between this list and other SharePoint lists.
1.PNG

Regards,
Lydia

SharePointAU
Frequent Visitor
‎06-01-2018 10:13 AM

Using the OData Connector works. Why do you think it doesn't like the SharePoint Connection?

Anonymous
Not applicable
‎06-05-2018 12:58 AM

@SharePointAU,

Have you cleared the cache?

Regards,
Lydia

SharePointAU
Frequent Visitor
‎06-05-2018 05:19 AM

Thanks for the follow up.

Yes. I cleared the cache as shown.

 

 

Vicky_Song
Impactful Individual
Impactful Individual
‎06-09-2018 02:32 AM
Status changed to: Investigating
 
samals
Regular Visitor
‎07-15-2024 06:19 PM

I am having the same issue. 

Idea Statuses