Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Receiving an error which I was hoping to receive some help with. I am attempting to connect to a Sharepoint list - when loading data into the model I receive the following error message:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] SharePoint:Request failed: the remote server returned an error: (406) Not acceptable. (The HTTP header ACCEPT is missing or its value is invalid.)
Thanks.
Hi,
Yes, we've encountered this issue with the SharePoint List connector.
Using Fiddler, I traced what the SharePoint List connector was doing.
You can see the blackbox connector is requesting JSON to come back as JSON Minimal. Unfortunately SharePoint PRE SP1 does not support JSON Light. In the SharePoint SP1 update it included an enhancment to add JSON Light support.
You simply need to amend the headers being sent using the SharePoint REST API however and ask for verbose JSON which is supported pre SP1, you won't be able to use the SharePoint List Connector blackbox as this does not allow you to customise any request headers..
My solution was to use the web connector to send your own SharePoint REST API call. Authentication remains the same if you were using kerberos.
URL: https://SITENAME/_api/web/lists/GetByTitle('YOUR_LIST_TITLE')/items?$top=5000
Header: ACCEPT application/json;odata=verbose
You should get data from the list but you'll get lots of metadat too, so you can just transform the data pick the columns you require.
I receive this error also. I am connecting to an on-premise sharepoint list. The data loads in the query editor but flags this error upon attempting to load the data into the model?????????
Can a Microsoft MVP and/or PowerBI Specialist please help with this issue?!
Did anyone get this resolved? If so, how ...
Hello,
receiving the following error when attempting to load data from a sharepoint list.
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] SharePoint: Request failed: The remote server returned an error: )4-6_ Not Acceptable. (the HTTP header ACCEPT is missing or its value is invalid.).
Thank you for your help!
Hi @mwand,
Could you please provide more information about your scenario?
1. Do you connect to on-premises SharePoint list or SharePoint Online list in Power BI Desktop?
2. How do you connect to the SharePoint list in Power BI Desktop? And what authentication type do you use?
3. What type of columns do you have in SharePoint list?
Thanks,
Lydia Zhang
Hi Lydia,
I am also getting the error:
1. In Power BI Desktop connecting to an on-premises sharepoint list
2. Using Windows Authentication
3. The list has the following column types:
Thanks.
Philip
Hi Lydia,
I am also experiencing a similar error. I am trying toconnect to a SharePoint List via teh SharePoint Online List in Power BI. THe list opens okay in the Query Editor, howevever, when I close the Query Editor window and apply the changes, I get the aforementioned error message in mwand's original post.
I am connecting to the SharePoint List using Windows authentication (AD) user credentials I believe. The columns contain mostly text and some numbers, but the datatype is general (any).
Any way to fix or otherwise resolve this issue?
Thanks
Did you ever resolve this issue? If so, please share.
I'm getting the following error message ["OLE DB or ODBC error: [DataSource.Error] SharePoint: Request failed: The remote server returned an error: (406) Not Acceptable. (The HTTP header ACCEPT is missing or its value is invalid.)]" and I appreciate the Power BI community forum feedback. However, I don't see that this conversation thread has a solution per se. Did you ever get this resolved? Does anyone else have any instructions or advise to help me with this issue (406)? If so, please help. Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.