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

[SharePointAU]

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? 

[v-yuezhe-msft]

@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.


Regards,
Lydia

[SharePointAU]

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

[v-yuezhe-msft]

@SharePointAU,

Have you cleared the cache?

Regards,
Lydia

[SharePointAU]

Thanks for the follow up.

Yes. I cleared the cache as shown.