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


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


  • Tableau Desktop 2020.2 or newer
  • OData


  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.


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?