Trying to connect to on-prem SharePoint list and getting error

[Anonymous]

We have an on-premises SharePoint server (soon to be O365) that I want to connect to a SharePoint list and get data from for a Power BI dashboard/report.  I am successfully connecting, but I get this error message and not sure how to proceed:

"Failed to save modifications to the server.  Error returned "OLE DB or ODBC error: [DataFormatError] OData: The format 'application/json;charset=utf-8' is not supported."

Is there anything I can do here?

Thanks for the information.

[v-qiuyu-msft]

Hi @Anonymous,

Based on my test in Power Bi Desktop 2.41.4581.361 and SharePoint 2013, use SharePoint List data source can get data from a list successfully.

In your scenario, would you please share how you create a SharePoint list? So that we can try to test in our environment.

Best Regards,
Qiuyun Yu

[Anonymous]

Very sorry for the delayed response as i was on vacation over the holiday season, but back at it today. 

I am using the November build of Desktop Power BI: Version: 2.41.4581.361 64-bit (November, 2016) and connecting to SharePoint 2010.

I did try to change the credentials from Windows to hardcoding my own in and I still get the same error

[v-qiuyu-msft]

Hi @Anonymous,

1. When you use SharePoint list data source, make sure the entered URL is site URL.

2. Try to connect to another SharePoint list.

3. Share the detail information about the list so that we can try to reproduce it.

Best Regards,
Qiuyun Yu

[Anonymous]

The exact URL is this: https://myportal.kcmhsas.net/rpt/Lists/SRR/Default.aspx

If I go here: https://myportal.kcmhsas.net/rpt it at least brings up the lists contained in that URL which SRR is one I want to connect to and cannot (where I get that json error).  If i use the full URL I get a 400 - Bad Request error. 

However when I try just a few other random lists, they work.  I retried the one I was getting that json error on and now I get this

[Greg_Deckler]

There is a similar issue here:

https://social.technet.microsoft.com/Forums/en-US/87309ab3-909e-4cc9-bf0f-ada2566b8266/odata-in-powe...

It is CRM Online, not SharePoint but the same error message so the solution may be the same.