#Tableau Desktop & Web Authoring270 discussing

We have a tableau dashboard using 2 different type of data sources- Snowflake and Google drive sheet. After changing the connection method from Username- password to Key-pair, scheduled extract run started failing. We are getting below error -  

This job failed on 16 Apr 2026, 14:25 after running for 0.1 min because of: com.tableausoftware.server.status.reporting.TableauRuntimeException: One or more connections in this data source need attention:myaccount.snowflakecomputing.com: [Snowflake][Snowflake] (31) Password not found. tableau_error_source=Client|tableau_status_code=16|tableau_error_code=0x28911C50

We have tried multiple changes like :-  

1. Made the changes in the data source connection to use the key placed at C drive of our system, republished the extract and then added the same credentials in the My account setting of Tableau Cloud. Republish is working fine , with all the data getting refreshed, but scheduled extract is failing . 

2. We have placed the key in the shared drive /Google shared drive , then also it is failing, so that it will be able to access the key, even without our personal folder  

3. We have put the connection parameters in the advanced tab of the tableau connection in desktop like -AUTHENTICATOR=SNOWFLAKE_JWT;PRIV_KEY_FILE=

C:\SnowflakeKeys\rsa_key.pem;  

but then also it is failing.   

4. We have republished the whole dashboard with different name, so that it can be treated as new extract, but that approach also failed. 

We are not sure, whether we are missing something on the connection setting between tableau and snowflake. Need help, if any one faced same issue or any one able to identify the root cause.  

#Tableau Desktop & Web Authoring

Hi,  

When I add dimensions into my LOD calculation, it over-inflates my values. How do I create an LOD calculation that won't over-inflate values, but will also work when filters are used without using 'Add to Context'?  The PERCENTILE calculation will not be utilized in a view. It will be used as a Filter to remove outliers.

For example, here are a couple of ways that I'm thinking I can approach this:   

Method 1:  Count items in the filter; when count is < max count then do this calculation, otherwise do this calculation.  

Method 2: Possibly use a nested LOD, but I'm not sure if this will even work the way I'm thinking it would.   

Method 3: Use sets to get around Add to Context, but I can't get the option to show up that says: "All Using Related Data Sources" when I try to use the set as a filter across data sources. 

But basically, this is what I'm trying to do something like this: 

When Filter is selected to (All), do this LOD:  

{FIXED [c.Choose Dates] : SUM([Sales])} 

When Filter has any item(s) selected, do this LOD, but this also inflates the values as well:

{FIXED [c.Choose Dates], [Sub-Category]: SUM([Sales])} 

**Disclaimer:  I can't use "Add to Context" or Table Calcs to solve this problem that is why I'm looking into alternative methods to approach this problem.  

**When trying to use an Exclude / Include (instead of FIXED), they need to be aggregated, but I need my percentile calculation to calculate on a row-by-row basis first, and then take the sum; so I was also running into a road-block with Exclude / Include as well. Maybe, I'm missing a step though, and that's why it's not working.

Thank you so much for any help on this! 

**Attached a sample workbook. 

#Tableau Desktop & Web Authoring

Hi everyone,

I have a table where each Selected Customer Type has multiple countries associated with it. I want to display all countries in a single row, separated by commas.

For example:

• Currys → United Kingdom
• AO → United Kingdom, France, Germany, Italy, Poland

I tried { FIXED [Selected Customer Type] : MIN([Country]) } but this only returns one country.

I know Tableau doesn't have a native STRING_AGG equivalent, but is there any workaround to concatenate multiple string values into a single cell without writing separate calculations for each value?

Note: I don't have access to Tableau Prep, and my data source is SQL but Selected Customer Type is a calculated field in Tableau so I can't use Custom SQL for this.

Any help is appreciated, thank you!