Forum Discussion

mwand's avatar
mwand
New Member
9 years ago

The HTTP header ACCEPT is missing or its value is invalid - SharePoint List

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 ...
mwand's avatar
mwand
New Member
9 years ago

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!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • timberwolf720's avatar
    timberwolf720
    Regular Visitor
    9 years ago

    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

    • gmohrman's avatar
      gmohrman
      Frequent Visitor
      8 years ago

      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,

    • gmohrman's avatar
      gmohrman
      Frequent Visitor
      8 years ago

      Did you ever resolve this issue? If so, please share.

  • phil_m's avatar
    phil_m
    Regular Visitor
    8 years ago

    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:

     

    • Date and Time
    • Single line of text
    • Choice
    • Number
    • Multiple lines of text (plain text only, no RTF)
    • Person or Group (single select)
    • Calculated field which uses DATEDIF on two other Date and Time fields in the list

     

    Thanks.

    Philip