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: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

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