Forum Discussion
Not able to Refresh from Sharepoint 2010 site 'application/json;charset=utf-8' is not supported
Hi All I am had a sharepoint 2010 list connected in power BI and was working fine. Not sure what changed but now the refresh wont happen. it gives me error OLE DB or ODBC error: [DataFormat.Error...
I'm having the same issue on SharePoint 2013.
Connecting via OData.
When I select the list I want, the preview pane shows the first row of data fine, but the second row of data has the word 'Error' in every column.
The list has calculated and lookup columns.
If you click load anyway:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error:[DataFormat.Error] OData: The format 'application/json;charset=utf-8' is not supported.. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. ".
yeah mine does the same thing. loads the first row and second row is error. I also have workflows built into my SP site.