KNOWLEDGE BASE

Error "(401) Unauthorized [HTTP/1.1 401 Unauthorized] Unable to create extract" Refreshing OData Extract


Published: 02 Jul 2021
Last Modified Date: 06 Jul 2021

Issue

When refreshing an extract that was created in an older Tableau version and uses the OData connector to connect to a SharePoint list, the following error may occur:

(401) Unauthorized [HTTP/1.1 401 Unauthorized] Unable to create extract

Environment

  • Tableau Desktop 2020.2 or newer
  • OData

Resolution

  1. Open the workbook that connects to the original data source.
  2. Select Data > New Data Source and create a new data source using the SharePoint Lists connector.
  3. Go to the sheet tab and select Data > Replace Data Source.
  4. In the Replace Data Source dialog box, select the Current data source and the Replacement data source.
  5. When finished, click OK.

Cause

The SharePoint Lists connector should be used for connecting to SharePoint Lists. OData connector was used instead of SharePoint Lists connector. 
Did this article resolve the issue?