How to Schedule Tableau Prep Flow

Manually running your Tableau Prep flows every morning takes time you could spend on actual analysis. Automating that repetitive task ensures your dashboards are always powered by fresh, clean data without you having to lift a finger. This guide walks you through the two main ways to schedule your Tableau Prep flows: using Tableau Server/Cloud and using the command line for local execution.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Automate Your Tableau Prep Flows?

Before diving into the "how," it's helpful to understand the "why." Setting your flows on a schedule isn't just a minor convenience, it's a fundamental step toward building a reliable and efficient analytics process. Here are the key benefits:

• Save Valuable Time: This is the most obvious win. Instead of remembering to open Prep Builder and click "Run" every day, week, or month, the process runs automatically in the background. That time adds up, freeing you to focus on finding insights rather than performing data chores.
• Ensure Data Freshness: Scheduled flows guarantee that your downstream Tableau dashboards and reports are always based on the most up-to-date information. Stakeholders can be confident they're making decisions with current data, not numbers from last week.
• Increased Reliability and Consistency: We all make mistakes - forgetting to run a flow, using the wrong input file, or getting pulled into another task. Automation eliminates human error, ensuring the preparation steps are executed consistently every single time.
• Optimize System Performance: Some data preparation flows can be resource-intensive, slowing down your machine or network. You can schedule these heavy-lifting tasks to run overnight or during off-peak hours, so data is ready and waiting for you when you start your workday without causing interruptions.

What You'll Need Before You Start

To follow this guide, you’ll need a few things in place. Getting these sorted out first will make the scheduling process much smoother.

• Tableau Prep Builder: You need the desktop application to create and edit your flows.
• Tableau Server or Tableau Cloud: To use the easiest and most robust scheduling method, you need access to one of Tableau's server environments. This is a licensed product separate from the desktop tools.
• The Data Management Add-on: This is crucial. To schedule flows directly on Tableau Server or Cloud, your organization needs this specific license add-on. It includes a feature called Tableau Prep Conductor, which is what actually enables and manages scheduled flow runs on the server. If the scheduling options you see are greyed out, it’s most likely because this add-on isn’t enabled for your account.
• Tableau Publishing Permissions: You’ll need a Creator or Explorer (can publish) site role on your Tableau Server or Cloud instance to publish your flow. You'll also need permission to connect to the relevant data sources.

Method 1: Scheduling on Tableau Server or Cloud (The Easiest Way)

This is the official, recommended method from Tableau. It uses Tableau Prep Conductor to manage everything within the familiar Tableau ecosystem. The process is straightforward and gives you a central place to monitor the status and history of your flow runs.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Publish Your Flow to the Server

You can't schedule a flow that only exists on your local machine. The first step is to publish it to your Tableau Server or Cloud environment.

1. Open your completed flow in Tableau Prep Builder.
2. Go to the top menu and select Server > Publish Flow.
3. You'll be prompted to sign in to your Tableau Server or Cloud if you haven't already.
4. In the publish dialogue, select the Project where you'd like to store the flow, give it a name, and add any tags or descriptions.
5. Important: Click "Edit" next to your data connections in the "Data Sources" section. For the scheduling to work without manual intervention, you need to embed the database credentials. Choose "Embed password" from the authentication dropdown and enter the credentials. This allows Tableau Server to access the underlying database on your behalf when the flow runs.
6. Click Publish.

Once published, the flow is no longer just a local file, it's an asset on the server that Prep Conductor can now access and run.

Step 2: Find Your Published Flow

Now that your flow is on the server, you need to navigate to it to set up the schedule.

1. Log in to your Tableau Server or Tableau Cloud site in your web browser.
2. On the left navigation pane, click Explore.
3. Find the project where you published your flow and click on it. Your published flow should appear in the list of content.

Step 3: Set Up a Scheduled Task

This is where you'll tell Tableau when and how often to run your flow.

1. Click on the name of your published flow to open its overview page.
2. You should see several tabs like "Overview," "Connections," "Scheduled Tasks," and "Run History." Click on the Scheduled Tasks tab.
3. Click the New Task button.
4. A dialogue box will appear with a list of available schedules. These schedules are typically set up by a Tableau Server Administrator.
5. Select a schedule that fits your needs (e.g., "Daily at 6 AM," "Weekly on Mondays," etc.). If you don't see one that works, you may need to ask your admin to create a new one.
6. Click Create Task.

That's it! Your flow is now scheduled. You can confirm it's working by going to the "Run History" tab after the first scheduled time has passed to see if it ran successfully.

Method 2: Using the Command Line for Local Scheduling

What if you don't have the Data Management Add-on or access to Tableau Server? You can still automate your flows using the command line tool built into Tableau Prep Builder and your computer's built-in task scheduler. This method is more technical and requires a bit more setup, but it’s a powerful workaround.

This process is best broken down into three parts: creating a secure credentials file, writing a script to run the flow, and scheduling that script to run automatically.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Create a Credentials JSON File

To run a flow from the command line that connects to databases, you need to store their usernames and passwords in a separate, secure file. A simple JSON file is the way to do this.

1. Open a plain text editor like Notepad (Windows) or TextEdit (Mac).
2. Create a JSON structure that defines the connection details. An example for a connection to a PostgreSQL server looks like this:

{
  "dbConnections": [
    {
      "hostname": "your-server-address.com",
      "port": 5432,
      "username": "your-username",
      "password": "your-secret-password"
    }
  ]
}

You can find the exact details for different connection types in Tableau's official help documentation. Save this file with a .json extension (e.g., my_prep_credentials.json) in a secure folder you can remember.

Step 2: Create a Script to Run The Flow

Next, you’ll write a small script file that tells the command line what to do. On Windows, this is a batch file (.bat). On a Mac or Linux, it's a shell script (.sh).

For Windows (.bat file):

1. Open Notepad again.
2. Type the command to execute your flow. The command points to your Tableau Prep Builder installation, your credentials JSON file, and your Tableau Prep flow file (.tfl or .tflx).

Your command will look something like this. Be sure to replace the placeholder paths with your actual file paths:

"C:\Program Files\Tableau\Tableau Prep Builder 2023.2\Tableau Prep Builder.exe" -c "C:\Users\YourUser\Documents\Prep\my_prep_credentials.json" -t "C:\Users\YourUser\Documents\My Tableau Repository\Flows\My Awesome Flow.tfl"

Breakdown of the command:

• The first part (in quotes) is the path to the Tableau Prep Builder executable.
• -c points to your credentials file.
• -t points to your flow file.

Save this file with a .bat extension, such as run_my_flow.bat.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Schedule the Script with Task Scheduler (Windows) or Cron (Mac)

Now you just need to tell your operating system to run that script on a schedule.

Using Windows Task Scheduler:

1. Search for "Task Scheduler" in the Windows search bar and open it.
2. In the right-hand Actions pane, click Create Basic Task...
3. Give your task a clear name, like "Run Daily Tableau Prep Flow." Click Next.
4. Choose your desired frequency (e.g., Daily, Weekly) under "Trigger." Click Next.
5. Specify the start time. Click Next.
6. For the "Action," select Start a program. Click Next.
7. Click the Browse... button and navigate to your .bat script file that you just created. Select it.
8. Click Next, review the summary, and click Finish.

Your computer will now automatically execute that batch file at your scheduled time, which in turn will run your Tableau Prep flow.

Troubleshooting Common Scheduling Issues

Sometimes schedules fail. Here are a few common problems and how to fix them.

• Flow Fails due to Permissions: This is the most common issue. The error message may mention access being denied. Double-check that the credentials you embedded in the connection on Tableau Server are correct and that the user account has access to read the source data and write to the output location.
• Schedule Options Are Grayed Out: This almost always means your organization does not have the Data Management Add-on license, or it hasn't been enabled for you. You'll need to speak with your Tableau administrator. If this is a no-go, the command-line method is your best alternative.
• Command Line Script Fails Silently: A script might not run and give no error. The most common cause is a typo in one of the file paths within your .bat file. Open Command Prompt, paste the full command from your script in, and run it manually. This will display any specific errors and help you debug.

Final Thoughts

Learning how to schedule a Tableau Prep flow is a major step toward making your data workflows more efficient and dependable. Whether you use the integrated tools in Tableau Server or the more manual command-line method, automating this process allows you to spend less time on repetitive tasks and more time generating valuable insights.

Mastering powerful tools like Tableau is essential for serious data preparation. However, we know that for many marketing and sales teams, the goal isn't just to prepare data but to get immediate, actionable answers from it without the complexity. That’s why we created Graphed . It allows you to connect all your data sources like Google Analytics, Shopify, and Salesforce, and then simply ask questions in plain English to build real-time dashboards and reports instantly, turning hours of analysis into a 30-second conversation.