如何使用Tableau命令行刷新多数据源连接的提取文件？

Hey there, I've run into this exact issue before when dealing with extracts that pull from multiple data sources. The problem with your initial command is that you're only providing credentials for one connection—Tableau can't authenticate the other linked data sources, hence the error. Here are the reliable fixes I've used:

Option 1: Use Stored Credentials with --all #

If you've already saved the credentials for all the data source connections in Tableau Server (either when publishing the extract or updating connection settings later), you can skip specifying individual credentials and let the command use the stored ones:

tableau refreshextract --server https://online.tableau.com --username user1 --password pass --project project --datasource data_123 --all

The --all flag tells Tableau to refresh all parts of the extract using the credentials already stored on the server for each connected data source. This is the simplest approach if you've already configured the connections properly in Server.

Option 2: Specify Credentials for Each Connection #

If you haven't stored credentials on Server, you need to provide authentication details for every data source connection linked to the extract. You can repeat the --source-username and --source-password parameters for each connection, matching the order they're referenced in the extract:

tableau refreshextract --server https://online.tableau.com --username user1 --password pass --project project --datasource data_123 --source-username connection1 --source-password pass1 --source-username connection2 --source-password pass2

If you're unsure about the connection order, you can verify it by checking the data source connections in Tableau Desktop or the Server's data source details page.

Option 3: Set Up a Scheduled Refresh in Tableau Server #

Since you need the extract to update every 10 minutes consistently, using Tableau Server's built-in scheduled refresh might be more reliable than manual CLI commands:

• Navigate to your published data source on Tableau Server
• Click Schedule > New Schedule
• Set the frequency to every 10 minutes
• Under the Credentials section, ensure "Embedded credentials" or the appropriate authentication method is configured for all linked data sources
• Save the schedule—Tableau will handle the refresh automatically without needing CLI scripts

This approach eliminates the need to manage external scripts and ensures all connection credentials are properly handled by the server.

内容的提问来源于stack exchange，提问作者Gulshan