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