Not able to Refresh from Sharepoint 2010 site 'application/json;charset=utf-8' is not supported

Hi All

I have also encountered the same error when trying to consume data from a SharePoint list.  After some investigation, I believe that the problem may be related to an error being raised by SharePoint rather than residing in Power BI.

To diagnose the issue, I enabled tracing in my report:

File > Options > Diagnostics > Enable Tracing

I then tried to refresh my report data, which resulted in the utf-8 error.

I then accessed the trace file that was created:

File > Options > Diagnostics > Open crash dump/traces folder

Close to the end of the "Microsoft.Mashup.Container.NetFX40.<system generated id>.txt" file, I located the request that had been sent to SharePoint.  I've generalised this below to remove my company specific data:

http://<mysharepointsite.com>/workareap/<myworkarea>/_vti_bin/ListData.svc/Actions?$select=Column1,Column2,Column3,etc

I copy/pasted this request into a browser and examined the resultant response that was returned by SharePoint.  I found that an incomplete XML document was displayed that contained a number of data records but was terminated by the following error section:

  <m:error>
    <m:code></m:code>
    <m:message xml:lang="en-AU">An error occurred while processing this request.</m:message>
  </m:error>

 The initial "<feed ...>"  tag was not ended with a corresponding </feed> tag.

As such, I believe that Power BI doesn't handle this very well, which results in the "utf-8" error being displayed.

I am currently trying to pursue with our IT people to determine what error is actually being raised by SharePoint.  As such, I don't yet have a resolution to this problem.  However, I thought it worth posting this information as others who have encountered the same error may be able to follow similar steps to those I have taken and may have better access to what's going on inside SharePoint.