Skip to main content

#Tableau Desktop & Web Authoring226 discussing

I published a workbook and connected it to a refreshed version of a data source; now it treats every calculated field like something that should be in the data source and throws up an error that it isn't present. How can I keep this from happening so I don't have to recreate the entire workbook just to update the data connection? 

 

#Tableau Desktop & Web Authoring

9 answers
  1. Today, 6:37 AM

    Check the schema changes first — renamed fields or different data types are usually the cause. Try Replace Data Source and Replace References before rebuilding the workbook. 

0/9000

Hello, 

 

We ran a simple transaction test with views using InteractVizLoadTest.jmx. we got the workbook (Performance.twb) as the output. However, whenever we try to launch, we get the below error. 

The Pg server is running and we verified access to the tables. Config was setup with port 5432. Not sure where the referenced port 48123 is getting picked up from. 

 

Want to run this by you all, to see if anyone came across this issue trying to launch the workbook? Would appreciate any help or pointers you give us in this regard. Thank you  

 

Tabjolt config question

 

 

 

#Tableau Desktop & Web Authoring

0/9000
5 answers
  1. Jun 12, 11:40 PM

    @Faizal Mohammed the tooltip you're displaying in your post is known as an 'Uber' tooltip.  Good luck on finding any documentation or history on it though.  I'm only aware of the nomenclature because I've been on the forums for about 13 years now and it come up from time to time.  This particular type of tooltip is imbedded in the software; and no, there's no ability to turn it off unfortunately.  You can however upvote the idea to allow a user to remove it in the Ideas Exchange here.

0/9000

Hi Experts, I am looking for a best solution for my scenario and appreciate your help.  The ask is i have to build a dashboard with 10 different visulizations but order of the visulaization should be based on end user selection. For suppose i have v1, v2, v3...v10 visulizations in 10 different worksheets. when the user open the dashboard he might selection any of those 10 worksheets on top of the dashboard and can select any remaining worksheets subsequently.  

User 1: v1, v3, v4,v8 so on 

User2: v10,v4,v3,v1 so on 

User3: v9,v6,v5,v1,v10 so on 

Oneway we can duplicate each sheet 10 times and set this visualization but i am looking for any effective way than duplicating 10 times. Appreciate any help or suggestions in this regard.  

 

Thanks, 

Murali. 

 

#Tableau Desktop & Web Authoring

10 answers
  1. Jun 12, 10:30 PM

    Hi, 

    Thank you for submitting your idea so quickly. :) 

     

    If you refine the wording a bit more to make it easier for a wider audience to understand, you may be able to gain more support.  

    For example, using 'worksheet' where appropriate instead of 'workbook' can help avoid confusion for readers. 

     

    You might consider providing the original question and your idea to a generative AI and asking it to improve the text. 

    If you're interested, I hope you'll give it a try. 

     

     

    One other thought came to mind.

    Are the users who want to control which visualizations they see and in what order primarily individual contributors, such as sales representatives, who are trying to monitor their own performance and daily activities?

    If so, another approach might be to provide a simplified mobile-friendly dashboard that focuses on only one or two key metrics. Users could then select the views most relevant to them and save them as a custom view for ongoing monitoring.

    On the other hand, if users are working as part of a team and need to align around common KPIs and objectives, allowing everyone to rearrange the dashboard independently could make communication and collaboration more difficult. In those situations, having a shared dashboard with a consistent layout may be more effective.

    For that reason, it may be worth considering whether the requirement is primarily for individual use or organizational/team use. If the use cases are different, maintaining separate dashboards for each purpose might be the better solution.

    This may not be exactly what you are looking for, but I hope it provides another perspective to consider.

0/9000

Attaching the workbook, I am getting the actuals till last month but the calculation named "YTD Sales CY (copy) "

is giving incorrect MTD forecast for the month of June 

 

#Tableau Desktop & Web Authoring

2 answers
  1. Yesterday, 8:53 AM

    Hi @Jim Dehner - Tableau Visionary HoF

    thank you for your help, I however want to achieve a field where the result should be the sum of highlighted numbers for June YTD (Actuals+Forecast), I ve tried various conditions but nothing seems to reduce the number 596k  

    Hi thank you for your help, I however want to achieve a field where the result should be the sum of highlighted numbers for June YTD (Actuals+Forecast), I ve tried various conditions but nothing seems

     

    none of the conditions are reducing the number from

0/9000

Hello Tableau Community!  

 

I am trying to write a calc that I can filter that will show accounts "with WiFi" and also "without WiFi".   

 

When I apply the following Calc (see picture), I can filter out to see accounts either "With WiFi" or the total of "With and without WiFi". 

 

Does anyone have thoughts on how I can achieve this?  Thanks in advance for any help you can provide.  

 

Charlie  

Calc Help: Excluding Accounts in Report

 

 

 

#Tableau Desktop & Web Authoring

5 answers
  1. Yesterday, 12:48 AM

    @Charlie Mouy

     

    Hi, in this case you may create a calculated field like:

    {FIXED [Name]:

    IF MAX([Si Cc Cd] IN ("HOMESYNC","WNS","HSP"))

    THEN "Has WiFi"

    ELSEIF MAX(NOT [Si Cc Cd] IN("HOMESYNC","WNS","HSP"))

    THEN "No WiFi"

    ELSE "Other"

    END

    }

    Then you can use this calculated field and COUNTD(Name). 

     

    Attached you will find the workbook. 

     

    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 updated the Athena DB connection credentials (username/password) in a Tableau workbook, and the extract refresh was working successfully after the update.

After around 5 days, I performed a web edit on the dashboard and made some changes. During this process:

  • Tableau did not prompt for credentials
  • While republishing, only the “Embed credentials” option was available

However, after republishing the workbook, the scheduled extract job started failing with an incorrect username/password error.

This is confusing because the credentials were already updated earlier and were working fine before the web edit.

 

My queries:

  • Why is Tableau not asking for credentials during web edit or republish?
  • Does web edit/republish overwrite or remove previously saved credentials?
  • Why would the extract fail with incorrect credentials even though they were updated earlier?
  • Is there any known limitation or behavior with Athena connections in such scenarios?
  • does role affect?

#Tableau Server  #Tableau Public  #Tableau Desktop & Web Authoring  #Tableau Cloud  #Tableau  #Tableau APIs & Embedding  #Tableau Community Updates

6 answers
  1. Yesterday, 7:25 AM

    Hi @Umesh Chorge

     

    dealing with WebEditing and credentials can be a bit unstable. I've seen a lot of instances over the years were credentials for some mysterious reasons were not committed or using old ones or using credentials from another tenants while the Analysts were working daily on multiples tenants.  

    This is one example: 

    https://help.salesforce.com/s/issue?id=a02Ka00000lYbc8IAC

     

    As you seem to work with embedded data source directly in the workbook, as Diego said in his earlier post, use published data sources. To keep your datasource stable and modify your workbook content irrelevant of Athena connections even in WebEdit. 

    And ideally you modify your published data sources using Tableau Desktop if you can.

0/9000

Tableau creatorからSalesforceにログインしてオブジェクトデータを引用したいと思っています。 

そこでTableau creator初期画面からSalesforceを選択し、常のごとくSalesforce authenticator AppによるMFA認証も済ませましたが、最終的に下記エラーになりました。 

 

データ ソース「データ ソースのタイトルが入力されていません」との通信中にエラーが発生しました 

接続不良: Tableau はデータ ソースに接続できませんでした。 

エラー コード:37CE01A3 

 

ちなみにSalesforce側の設定"Connected Apps OAuth Usage"については、"TableauID"および"Tableau Desktop"ともにインストール済です。  

諸先生の方々、どうかお助けを。 

 

#Tableau Desktop & Web Authoring  #Salesforce

3 answers
  1. Yesterday, 12:27 AM

    Many thanks for prompt responses! 

    At first, I did the final step to allow access.  

    The error comes up just after clicking 'allow'. 

    On the other hand, please kindly let me know where the 'API enable permission' could be set? Should it be in SFDC setting menu?

    Many thanks for prompt responses! At first, I did the final step to allow access. The error comes up just after clicking 'allow'.

     

    FYI, Microsoft power query can import SFDC objects via 'connected App OAuth'(see below the screenshot).

    image.png

     

    Best 

    Endo

0/9000

Hi Community, 

 

I am facing two related errors on a Tableau Server workbook and Tableau Desktop that uses an  

Extract connected to Snowflake only for a single workbook other workbooks are working fine. 

 

--- 

 

ENVIRONMENT: 

- Tableau Server (hosted) 

- Data Source: Snowflake (Extract mode, NOT live) 

- Authentication: Embedded credentials 

- Extract contains all data, no extract filters applied (Filters: 0) 

 

--- 

 

ERROR 1 — Tableau Server (when opening dashboard): 

SQLSTATE:53S03 — Cannot allocate 620,576,768 bytes of memory 

The local transaction memory limit of 21,474,836,480 bytes was exceeded 

 

--- 

 

ERROR 2 — Tableau Desktop (when refreshing extract): 

Error Code: AE406838 

SQLSTATE:53100 — unable to grow file partition 

--- 

 

DATA MODEL DETAILS: 

The data source has Snowflake gold tables with joins. 

No extract filters are applied — extract contains ALL data. 

 

--- 

 

 

QUESTIONS: 

1. Is this confirmed to be a Tableau Server disk space issue? 

2. What is the recommended way to solve this. 

 

 

Any help appreciated. I will attach screenshots below. 

 

#Tableau Server  #Tableau Desktop & Web Authoring

4 answers
0/9000
2 answers
  1. Yesterday, 8:23 PM

    @Okeke Emelda

     

    This error appears because with Tableau Public you can only open workbooks whose datasources are extracts.  So, maybe you forgot to extract the data (yeah, I understand Tableau Public should expose like a warning that the datasource is not extracted). 

     

    May you post your twb/twbx and the file you are using (Excel, csv, or other)?. Thus, we can build the extract using Tableau Desktop Professional, and upload again the packaged workbook so you can use it in Tableau Public? 

     

    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