Loading

SharePoint Lists Extract Refresh Fails on Tableau Server with "401 Unauthorized" Error

Udgivelsesdato: Jan 17, 2025
Beskrivelse

Issue

When refreshing a SharePoint Lists extract created with Integrated Authentication specified in the data connection, the refresh fails. Background Tasks for Extracts report shows an error of:

"401 Unauthorized."

 

Cause

When Integrated Authentication is specified for connection to a data source, Tableau Server uses the Run As User account to perform extract refreshes for extracts from that data source. The Run As User account must therefore have permission to access that data source.

Note: This applies to the "SharePoint Lists (deprecated)" connector, not the "SharePoint Lists (JDBC)" connector. Integrated Authentication is one of the authentication options available for "SharePoint Lists (deprecated)" connector, but is not one of the authentication options available for the "SharePoint Lists (JDBC)" connector.

 

Løsning

Option 1

Give the Tableau Server Run As User account access to the SharePoint List used by the extract.

 

Option 2

Use "Username and Password" to connect to the SharePoint List, and ensure the user has access to the SharePoint List.

 

Yderligere ressourcer

Vidensartikelnummer

001471505

 
Indlæser
Salesforce Help | Article