Forum Discussion
Trying to connect to on-prem SharePoint list and getting error
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.
5 Replies
- Greg_Deckler
Community Champion
There is a similar issue here:
It is CRM Online, not SharePoint but the same error message so the solution may be the same.
v-qiuyu-msftCommunity Support
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 YuVery 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
