Error "Cannot extract required information from IDCRL header" Connecting to SharePoint List
Published: 08 Mar 2018 Last Modified Date: 20 Jul 2023
Issue
When trying to connect to a SharePoint List, the following error may occur:
Client unable to establish connection Cannot extract required information from IDCRL header, Header=, IdcrlType=, ServicePolicy=, ServiceTarget=, Endpoint=
Environment
Tableau Desktop
Windows
SharePoint Lists
Resolution
Solution 1: Work with your IT team to verify that the correct Edition is selected in the SharePoint Lists connector dialog box: it should be On Premise if the above error occurs when the Authentication method is Username and Password.
If the Authentication method is Third-party SSO, verify that a supported third-party SSO product is used.
Solution 2: Work with IT team to troubleshoot network connection issues.
Cause
Cause 1: The incorrect Edition is selected in the SharePoint Lists connector dialog box, or an unsupported third-party SSO product is used.
Cause 2: There are connectivity issues between the Tableau Server and the Sharepoint site (i.e. navigating to the Sharepoint site through the browser will return an error)
Additional Information
The third-party SSO products that are currently supported with the SharePoint Lists connector are OneLogin and Okta.
For troubleshooting network connectivity issues, you may use tools such as Wireshark and/or Fiddler to gather logs
1. Generate a wireshark log that captures the traffic on Tableau Server during an attempted refresh of the Sharepoint data source. In the log, you will see that shortly after the DNS lookup of the Sharepoint site there will be a reset connection, which is what is triggering the extract to fail.
2. Use fiddler to capture an attempted load of the Sharepoint site in a browser.
Thank you for providing your feedback on the effectiveness of the article.