Troubleshooting

This page helps with Tableau troubleshooting

Snowflake connection fails in extract due to invalid authorization

The source of the issue is unknown, but you can take a couple steps to resolve the issue:

    1. Login to Tableau server at: https://tableau.wisconsin.edu/
    2. On top right hand corner, click on your icon (1 in the image below)
    3. From the menu, choose “My Account Settings” (2 in the image below)
    4. Make sure you are on the “Settings” tab (3 in the image below)
    5. Scroll down until you see “Snowflake” (4 in the image below)
    6. Delete the credentials you see (5 in the image below)
    7. After deleting, we want to re-add it. Click “Add” (6 in the image below)
    8. In the pop-up window, specify the following settings:
      • Instance URL: laa66896.us-east-1.snowflakecomputing.com
      • Role: leave it blank.
    9. Authenticate through NetID Login and click Allow.
    10. Run the extract refresh and see if it runs error-free

setting page

Snowflake Connection fails in Tableau Desktop

If you see an error like this when you try to connect to Snowflake:

Snowflake connection error on Tableau desktop

Please follow these steps:

      1. Close Tableau if it’s open.
      2. Go to Control Panel > Programs > Programs and Features.
      3. Find Tableau in the list of programs. Click Uninstall/Change.
      4. Click Repair in the pop-up window.

If that fails, then uninstall and re-install Tableau (you’ll likely need to have your product key at hand, just in case Windows doesn’t remember it).

Invalid username or password error on publish

On the publish window, click the “Edit” under “Data Sources”. Then click the dropdown for your Snowflake connection and choose yourself. Like this:

choose user

The lost connection error

This error means you need to sign in to GlobalProtect VPN:
VPN Error

Error "The crosstab exceeds the size allowed and cannot be exported." Exporting to Crosstab

Tableau Server has a limit 33,554,432 cells for downloading csv from crosstab. Limit the data by filtering before downloading it and it should resolve the issue. 

 



Keywords:
Snowflake, Tableau 
Doc ID:
116564
Owned by:
Noah L. in Data KB
Created:
2022-02-07
Updated:
2024-05-01
Sites:
Data, Academic Planning & Institutional Research