Skip to main content

#Tableau Prep32 discussing

I don't know if it is related or not but after updating to the most recent prep version I'm unable to publish from desktop to cloud. I tried downloading a few prep flows from cloud, turning around & republishing them and am running into the problem.

 

Uninstalling and reinstalling now to see if this fixes the problem.

[edit] that did not work

[edit] uninstalled 2024.2.2 and reinstalled 2024.2.1

[edit] With 2024.2.1 I was able to publish the test flow I had just downloaded from Online but still unable to publish the flow I needed

[edit] I found a workaround which was to publish as saved steps the entire flow absent the output. Once I had the steps open in Tableau Online I was able to add an output and publish without error.

5 answers
  1. May 18, 6:03 PM

    I'm having this same issue. I am modifying a prep flow that exists on our Tableau server. I usually download the prep file and edit via the desktop app, however, when I go to publish I get same vague unhelpful error message. Even if I try to publish that same prep flow with no edits, it will show me the error if I try to publish (this is an unedited prep flow that had previously been published without issue). Anyone encountered this before?

0/9000

For the last few days, I have been having issues with a flow that was working before. I need to publish it to the server after making some changes, but it repeatedly gives me a "Error publishing flow to Tableau Server." After some painstaking troubleshooting, I've narrowed the problem down to a deduplication step. If that step is there, it will not publish. If that step is NOT there, it publishes fine.  

 

This step is not a new part of the flow, it is also in the currently published version that has been running fine for months. 

 

Any suggestions? I do really need that deduplication step! 

 

#Tableau Prep

3 answers
  1. May 15, 7:06 AM

    Hi @Courtney Crawford

     

     

    I have a workbook on Tableau Public to check if an issue you face in a version of Tableau Prep has been resolved in a later version.  

     

    https://public.tableau.com/app/profile/matthias.giger2774/viz/ResolvedIssuesTBS/TableauServerResolvedIssueChecklist

     

     

    Maybe your issue has been resolved in a higher version of Tableau Prep. If an upgrade is an option this could resolve your issue. However if you cannot spot the issue you face, the upgrade to a newer version would not help.  

     

    Best 

    Matthias 

0/9000

Hi everyone,

I’m struggling to get Tableau Prep to recognize my TabPy server on macOS. Despite several attempts, Prep doesn't seem to establish a connection to the local server, and I’m hitting a wall.

I have been using the exact same Python scripts that work seamlessly on Windows. Even after updating the file paths and environment configurations to match the Mac file system, the connection fails. This leads me to believe it might be an issue specific to how Tableau Prep handles external service connections on macOS, rather than a script or tabpy error itself. 

 

#Tableau Prep

0/9000

I am using Tableau Prep to manipulate data from .csv files and upload the data to a MySQL database. When reading the .csv files, Tableau Prep determines the data type of all columns automatically. However, for some columns of some tables, it determines the datatype incorrectly. I have investigated what is happening.

 

One of the tables has 7501 rows. In certain columns, the first 1335 of these rows contain just a 0. The 1336th row contains a decimal number, and other rows further down do as well. However, Tableau reads this column as a “whole number”. I now I can manually change the datatype of a column, but this does not not help me, since then I would need to manually configure the datatype Tableau Prep reads in for 250 columns for 29 .csv files I am reading (=7250 columns !!!). And even if I would actually do this all manually, the number of manual operations that I have then defined seems to be to much for Tableau Prep to handle (I have tried it for a single table, which was not successful, the flow never completed loading).

 

Is there a solution to make sure I am reading in all my data correctly? Or will I have to resort to resolutions outside of Tableau Prep? 

 

#Tableau Prep

3 answers
  1. May 1, 12:19 AM

    @Jop de Boo

     

    What you say is true. Tableau Prep uses the first 1000 values to infer the data type. 

     

    As a workaround, if you change the 0 value to 0.0, Tableau will infer the column is a decimal, and therefore, you won't need to change the field type. 

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

Hi Community, 

 

I’m currently facing an issue with my data refresh and would appreciate any guidance.

I’m unable to view the refreshed data from my Salesforce source, even though I have enabled refresh access in my Tableau Prep flow. There are no errors shown in the Jobs section on Tableau Cloud. However, when I check the Output step of my flow, I encounter the following error:

“Unable to run output step: Wait for cache write operation has terminated due to a failed write.”

For context, my flow currently outputs around 5 million rows, and the data volume is increasing daily rather than decreasing.

I have a couple of concerns:

  •  What could be causing this cache write failure despite no visible job errors? 
  •  If my output grows to 10 million rows (1 crore), will this impact my flow performance or dashboard reliability? 
  •  Could increasing data volume prevent updated values from reflecting correctly in my dashboards in the future? 

Any insights or suggestions would be greatly appreciated. 

 

Thank you! 

 

#Tableau Cloud  #Tableau Server  #Tableau Cloud  #Tableau Prep

2 answers
  1. Apr 30, 10:41 AM

    Hi, 

    You can apply a filter using the input icon.  

    This is more powerful than filtering in the middle of the flow and can reduce the amount of data loaded.

    Hi, You can apply a filter using the input icon. This is more powerful than filtering in the middle of the flow and can reduce the amount of data loaded.

     

    Also, if it's possible to apply a filter using SOQL, it might be worth considering that as well.  

     

    First, it would be good to narrow down the data volume and test what happens. If the issue is due to the amount of data, you may need to consider strategies such as adjusting the data retention period.  

     

    I hope your problem gets resolved.

0/9000

Tableau Server上でパーミッションがついているのに、Prepでのデータソースパブリッシュが出来ません。

  • ローカルでのPrep実行:パブリッシュ出来たり、出来なかったりします
  • Server上でのPrep実行:毎回パブリッシュ出来ません

→いずれも「パーミッション不十分です」のエラーが出ます。    実行者のサイトロールはCreatorであり、パブリッシュ先のプロジェクトに十分はパーミッションがあることは確認しています。  ローカル実行で出来たり出来なかったりというのも謎です。原因としては何が考えられますか?   

6 answers
  1. Apr 20, 4:36 AM

    Overweite権限が抜けている可能性はないですかね? 

    ローカルで1回パブリッシュできるけど、それ以降ができないならいかに該当する可能性あります。 

     

    Tableau では「パブリッシュ」と一言で言っても、中身は2種類あります。 

    操作必要な権限新規データソースの作成(初回パブリッシュ) | プロジェクトの Publish

     

    既存データソースの上書き(2回目以降) | 対象データソースの Overwrite + Save As + Connect

      

     

     

    確認方法 

    1. パブリッシュ先プロジェクトに、同名のデータソースが既に存在していないか
    2. 存在する場合、その個別のデータソースの権限(プロジェクト権限ではなく!)で、実行ユーザーに以下がすべて Allowed になっているか確認: 
      • View
      • Connect
      • Overwrite ← これが抜けているケース多数
      • Save As(Download/Save As)

      

    もしくは、 Flowの権限周り?

    Flow のオーナーと実行者が別の場合、Flow はオーナーの権限で動きます。Flow owner が出力先データソースに対して Overwrite を持っていないと失敗します 

0/9000

The upper row is the original data.

I want to create this data with tableau prep as shown below

I am a beginner.

 

Processing with Tableau prep 

 

How should it be processed?

Please teach me.

2 answers
  1. Sep 26, 2022, 1:25 PM

    @TOSHIHIEO EBATA​ 

    Hi, welcome to Tableau, in this case you can use a pivot step:

    @TOSHIHIEO EBATA​ Hi, welcome to Tableau, in this case you can use a pivot step:You can watch the training videos in: In the Tableau Prep section:If this post resolves the question, would you be so kiYou can watch the training videos in:

    https://www.tableau.com/learn/training/20202

     

    In the Tableau Prep section:

    imageIf this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador

0/9000

When creating prep flows is there a way in the platform to create specific documentation of the steps that were performed to create the flow? We are in the process of creating documentation for all of our flows and was wondering if this is a feature in Prep or do we need to use ChatGPT or Gemini to create it? Thanks in advance. Vivian 

 

#Tableau Prep

6 answers
  1. Apr 2, 2:58 PM

    Aside from renaming a step or adding a description of that step in the flow (limited to 200 characters), no there isn't a method of doing that.  The description is helpful, but only if its high-level, as to what's occurring within a particular step.Aside from renaming a step or adding a description of that step in the flow (limited to 200 characters), no there isn't a method of doing that.

     

    You may want to consider creating an Idea in the

    Ideas Exchange for something like a longer comment option in the menu?

0/9000

When I make a calculated field in Prep using a field with a type change, the data does not appear in the reulting datasource. For example, I had a Datetime field that showed the amount of time something took. I converted it to a string, then added the minutes and the hours (times 60) to get the total number of minutes the event took. Everything looks great in the flow. When I run the flow and open the datasource (or open a workbook based on the datasource), no data appears for that column. It's all Null. This has happened repeatedly recently, allways when I have converted the field type and made a calculation. Any suggestions? Is this happening for anyone else? 

 

All my data is highly confidential, so I cannot share it here.  

 

#Tableau Prep

5 answers
  1. Apr 8, 11:35 PM

    @Kate Ory

     

    Hi, could you paste a screenshot of the changes section of the clean step so we can take a look of what you are doing, and suggest and alternative. 

     

    My best understanding, is that you are converting your datetime field to string using: 

    STR([yourdatetimefield]) 

     

    (Maybe you are using the automatic conversion by clicking on the data type icon an selecting string.  Sometimes automatic conversion may cause errors, so that I prefer to use STR([Field]) 

     

    And then you are extracting the parts of the string related to the hour and minutes, and then you are converting them to INT, and finally multiplying and adding them to obtain the total duration in minutes. 

     

    As a workaround, I suggest you to use your datetime directly (it should be a datetime data type field), and obtain the dateparts using something like:

    DATEPART('hour', [yourdatetimefield]) * 60 + DATEPART('minute', [yourdatetimefield])

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

I keep getting the below error while running the flow to refresh the tables in SQL.    Something went wrong. Error: An error occurred while communicating with the data source An error occurred while communicating with the data source Invalid Query Fatal Error(1,1): invalid document structure (id: ) class DataSourceException. Try rerunning the flow.    It is running fine in tableau prep desktop and I am able to create/refresh it manually.     

8 answers
  1. Apr 8, 10:06 AM

    We are using PostgrSQL and we are also trying to writeback from Tableau Cloud to on premises databases uding tableau prep but its not working. Write back option is not available on Tableau cloud.

0/9000