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 ...
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.