How to Fix Tableau Prep Flow Refresh Failure in Tableau Cloud with On-Prem Data

Blog | September 14, 2023 | By Shaswath Thunga Devaraj URS

Introduction to Tableau Prep and Data Preparation

Overcoming Tableau Prep Flow Refresh Challenges

Do you want to prepare your data for analysis and visualization in Tableau? If so, you might have heard of Tableau Prep, a tool that helps you clean, shape, and combine your data. Tableau Prep makes data preparation easy and fast, and lets you connect to Tableau Desktop or Tableau Server for further exploration.

But what if you encounter a problem when you publish your Tableau Prep flow to Tableau Cloud? What if your flow fails to refresh when your input is an on-premises database connection that is not published?

The Challenge: Tableau Prep Flow Refresh Failure

This is a recurring challenge that frustrates users to no end, often taking hours to fix.

Desktop Version Output:

Tableau Cloud Output:

In this blog post, I will show you an easy workaround to solve this challenge and make your Tableau Prep flow refresh successfully in Tableau Cloud.

Identifying the Issue

Understanding the Frustration

The Solution: Troubleshooting Tableau Prep Flow Refresh

Here’s how you can do this:

Step 1: Publish the Input Connection

Test Table should be published as a data source before it is used in the Tableau prep flow.

Step 2: Replace the On-Premises Connection

Now replace the input connection from on-premises connection to data source that was published to Tableau Cloud.

Flow with input connected to on-premises database.

Flow with published data source as the input.

Step 3: Now Publish the Flow to Tableau Cloud

Step 4: Refresh the Flow in Tableau Cloud

Conclusion: Successful Data Preparation in Tableau Cloud

By following these four steps, you can avoid the tableau prep flow refresh failure in tableau cloud with on-premises data and ensure that your data is up to date and ready for further analysis and visualization.

Ensuring Data Accuracy and Readiness

Thank you for reading and happy data prepping!

About the Author
Shaswath is a highly skilled software engineer with proficiency in Alteryx, Oracle, Snowflake, Teradata, and Tableau. His experience encompasses the information technology and services sector where he applies his expertise in data transformation, analytics, and visualization to provide valuable insights for clients.
Shaswath Thunga Devaraj URSTechnical Lead - Visual Analytics | USEReady