KNOWLEDGE BASE

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


Published: 20 Apr 2017
Last Modified Date: 30 Aug 2017

Issue

When connecting to SharePoint Lists online edition, the following errors may appear:
"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.
"

Environment

  • Tableau Desktop 10.2.0
  • Microsoft SharePoint

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?