KNOWLEDGE BASE

Error: "Client unable to establish connection Failed to get security cookies of SPOnline" Connecting to Sharepoint List Online


Published: 20 Apr 2017
Last Modified Date: 22 Feb 2018

Issue

When attempting to connect to list on SharePoint Online, the following errors may occur:
Client unable to establish connection You must either set an auth cookie or specify a username and password to connect to SharePoint Online
Failed to get security cookies of SPOnline.
or
Client unable to establish connection HTTP protocol error. 404 Not Found.

Environment

  • Tableau Desktop
  • Microsoft SharePoint Online

Resolution

Make sure that the correct URL is being used for the connection:
  1. Site Name does work: https://example.sharepoint.com/sites/SiteName
  2. Site Collection does work: https://example.sharepoint.com/sites/SiteName/CollectionName
  3. Base domain name does not work: https://example.sharepoint.com
  4. Direct URL does not work: https://example.sharepoint.com/sites/SiteName/CollectionName/SitePages/Home.aspx
  5. OData Service List URL does not work: https://example.sharepoint.com/sites/SiteName/_vti_bin/Listdata.svc
  6. OData Service URL does not work: https://example.sharepoint.com/sites/SiteName/_vti_bin/Listdata.svc/OtherName
Did this article resolve the issue?