Skip to main content
Topics#Tableau Public

#Tableau Public84 discussing

Ask a question...
Aubrey Perry
May 18, 10:49 PM
Problem Downloading Dataset via CSV

I have a dashboard published on Tableau Public that has been live for about 10 years. To allow people access to publicly accessible data, we publish a direct link that allows user to download the dataset via .csv. Here is the direct link to the dataset: https://public.tableau.com/app/profile/portlandpolicebureau/viz/PPBOpenDataDownloads/New_Offense_Data_2016.csv

 

 

Sometime recently, the download link is no longer working correctly. Users to get a 404 message that prevents the download from beginning. 

Problem Downloading Dataset via CSV

 

We have double checked all of the links and re-uploaded the relevant dashboard; however, it has not fixed the issue. I believe this is similar to the issue posted in the

#Tableau Public

Trailblazer last month, but that thread seemed to imply the issue was fixed. 

 

If anyone has information on how to fix this issue or elevate it to the tech support team, I would love to hear about it! 

 

Thank you.

5 answers
  1. Étienne Hossack (Tableau)
    Yesterday, 12:22 AM

    Hi Aubrey. As of right now the functionality to download directly via url ".csv" extension is unavailable but we've been made aware of several use cases which require this functionality to work, so we're working to restore it.

Write an answer...
0/9000
Michael Wolf (Consultant at Mike Wolf Consultants LLC)
Yesterday, 8:24 PM
How do I add additional Excel tables to my Tableau data source?

I believe I have tried everything; checking Tableau site for instruction, adding a data source, refreshing data source. When I add a new table and tab to my Excel source file, I cannot get them to show up in Tableau workbook. I only see the tables from the original loading of my Excel workbook. When I go to 'add a source', it only brings up the source workbook again, not individual tables. After I select the same workbook again and refresh the connection, no new Excel tables appear. I don't think I need to create a new Excel workbook every time I add data, or, do I?  Thank you!  

 

P.S. Sometimes a new table will be added as a data source, however when I drag the table into the data source area, I get this message. Sometimes, it causes a crash and I lose my entire workbook.   

Unable to complete action 

Bad Connection: Tableau could not connect to the data source. 

Error Code: 81B3934F 

An error occurred while communicating with data source 'Sales!Sales_Table (Electric Cars)'

 

#Tableau Public

Write an answer...
0/9000
Pavan Kumar asked in #Tableau Desktop & Web Authoring
May 18, 1:22 PM
Dynami Start & End date Parameters controlled Snapshot Date

Hi All, 

 I can't upload full data, so i am created some dummy data with Tableau workibook. 

Find the requirement.

  • The default range for Order Date must include the last 9 quarters.  
  • Only the current quarter can be a partial quarter 
  • The Start Date must always include the 1st day/month from 9 quarters prior 
  • The End Date should match the selected Snap Date 

 

Examples: 

  • Snap Date = 6/30/2026, start date = 4/1/2024 
  • Snap Date = 5/31/2026, start date = 4/1/2024 
  • Snap Date = 4/30/2026, start date = 4/1/2024 
  • Snap Date = 3/31/2026, start date = 1/1/2024 
  • Snap Date = 2/28/2026, start date = 1/1/2024 
  • Snap Date = 1/31/2026, start date = 1/1/2024
  • Start & End date parameters should be based on Order and controlled by Snap date 

I tried some wor around but not working.

Thanks in Advance. 

 

#Tableau Desktop & Web Authoring  #Tableau Public  #Tableau Next  #Tableau Desktop & Web Authoring

Dynamic Start & End.twbx
3 answers
  1. Dan Chissick (Naya Technologies)
    Yesterday, 7:39 PM

    Then you don't need any parameters at all. 

    Just change your Order Date Selector field to:

    [Order Date] >= DATEADD("quarter", -8, DATETRUNC("quarter", [Snap date]))
    AND
    [Order Date] <= [Snap date]

    and then filter it to True. 

     

    In any case, you can't use a filter to change a parameter value. 

     

Write an answer...
0/9000
Waalstad Internet
Apr 12, 3:29 PM
Cannot download data anymore from Tableau Public

Tableau Public error.  

I cannot download data anymore from different maps. I get a 404 from Tableau. See picture. 

Anybody knows why? 

 

Fred   

Cannot download data anymore from Tableau Public

 

 

 

#Tableau Public

9 answers
  1. Cody Gabbard
    May 18, 8:59 PM

    We just started seeing it today again, is anyone else having the same issue?

Write an answer...
0/9000
Jean-Paul Frenett
Mar 22, 2020, 1:23 AM
Help Automatically Adjusting Dates to Match

Hi all,

 

I'm pretty sure I got fairly close with this, but now I'm too deep into the problem and can't see the wood for the trees.

 

The dataset is Covid-19, and I'm looking, for example, at the number of cases per country.

I would like to have a line for each country, with the line starting at a common point, such as when a country reaches 500 cases.

 

I have manually created it and adjusted the dates on the Tab 'Over 500 cases'.

But I would like to be able to adjust the number, and for new countries to automatically work.

 

I had thought I would be able to use a level of detail to find the minimum date when a value was first reached,

calculate the difference between that date and the latest date in the data.

 

I ran into issues as (maybe) the USA numbers (and some others) are made up of multiple states, whereas another country would just be a single line.

 

You'll see some attempts to do it on the following fields:

  • Over Case Limit
  • Over X Cases
  • Min Country
  • Different in Dates
  • Baselined Dates

 

Workbook on Tableau Public here:

Tableau Public

 

eg:

 

Help Automatically Adjusting Dates to Match

8 answers
  1. Jimmy Zhang (Sprint Milestone)
    Mar 22, 2020, 3:11 AM

    Hi Jean,

     

    You can use one of table calculation help function index() to achieve the common baseline comparison.  An example will be on Tableau blog Top 10 Tableau table calculations | Tableau Software case 2.

     

    Back to your case, here is the solution.

    Step 1. Create one calculated field [# of days Since 500 cases] whose formula is simple as INDEX().

    Step 2. Drag and Drop [Date] into details and choose date value day as details, also change the mark type to Line chart.

    Step 3. Replace [Manually Adjusted Date] on columns with [# of days Since 500 cases], configure Table Calculation direction as Computing Using > Date.

     

    you can find the solution in attachment.

    Hi Jean, You can use one of table calculation help function index() to achieve the common baseline comparison.

    Cheers

     

    Jimmy Zhang

Write an answer...
0/9000
Kathy Kaufman
May 5, 7:34 PM
Tableau Desktop laggy and "not responding"

I'm using Tableau Desktop (public edition) 2026.1.1 to edit multiple workbooks on my Win 11 workstation and the program is suddenly extremely laggy. Just selecting dashboard objects causes a multi-second delay where a blue circle spins and "Not Responding" appears in the status bar alongside the dashboard name at the top of the screen.  

 

Is anyone else experiencing this issue? I've edited these workbooks repeatedly without issue over the past few weeks, so I'm wondering if this might relate to the service outage 2 weeks ago that resulted in Error Code: 9F4C5638. 

 

I'd appreciate any input! 

 

#Tableau Public  #Tableau Desktop & Web Authoring

8 answers
  1. Kathy Kaufman
    May 18, 12:47 PM

    @sakino harada I can edit the same workbooks from home without any issue, so in my case the problem is definitely related to my work computer settings. Still waiting for IT to allow Tableau.exe through the firewall :/

Write an answer...
0/9000
Jeremy Siegfried
May 9, 10:05 PM
Help needed with ranking calculation

I cannot for the life of me get a ranking calculation to work properly. I have spent a couple hours at this point googling and trying various solutions. I'm probably missing something obvious (I haven't used Tableau much in the past year), so any help would be greatly appreciated! 

 

I want to rank players by their total wins. This works easily enough until I add another dimension to color. At this point, RANK and INDEX both return unexpected results, and no amount of fiddling with the table calc settings seems to be able to get it working. Packaged workbook attached. 

Grand Slams in the Open Era.twbx
3 answers
  1. Ilija Stojic (Toyota Motor North America)
    May 11, 3:34 PM

    I attached a packaged workbook that solves this two slightly different ways. Both use RANK_DENSE(), because you are ranking players by their total win count but displaying it with additional dimensions (e.g. tournament). This will cause "ties" and probably not what you want. 

     

    When you edit your table calc settings (via right-click -> Edit Table Calculation), you should use the "Specific Dimensions" option and check everything for the Rank pill. For each player's wins, you would:

    1. Table calc: Uncheck what the ranks should be grouped by (e.g. Player) 
    2. Fixed LOD: Ensure the dimensions listed are the level you're calculating at (e.g. Player)

    You will need to repeat the Edit Table Calculation process each time you add a dimension to the sheet. (e.g., if you add Year, for the Rank pill you would need to go back and check Year, assuming you still want it by total wins.) 

     

    There's a nice explainer for table calc addressing vs. partitioning here: 

    https://tableauadventurer.com/2024/05/31/mastering-table-calculations-pt-1-from-basics-to-advanced-settings/

     

     

    Hope this helps!

    Grand Slams in the Open Era v2.twbx
Write an answer...
0/9000
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
Oct 17, 2024, 8:17 AM
How to load a large dataset into tableau desktop ? How to view all French cities in a tableau desktop ?

Hello

I would like to use Tableau to carry out an analysis of the real estate market in France, but I am faced with two difficulties. The first difficulty I can't produce analyses on my entire dataset. I load my dataset as a data so. urce, but on my spreadsheet I only work on an extract of my entire datasetThe second difficulty. I can't geographically represent all the cities in France, even though I have identifiers in my dataset that allow me to do so in other software. Here are the open data links for downloading the data I want to use.

https://www.data.gouv.fr/fr/datasets/demandes-de-valeurs-foncieres/

dvf_1.csv
1 answer
  1. Ryosuke Yamashita
    May 12, 2:45 PM

    Hi, 

     

    Here are a few things to check and try: 

     

    1. Verify your connection type 

    In Tableau Desktop, when you connect to your CSV, make sure you select "Extract" rather than "Live" in the top-right of the Data Source tab. A Live connection to a large CSV can be slow and may not behave as expected. 

     

    2. Check for unintended Extract filters 

    Click "Edit" next to the Extract option and confirm that no row filters or "Top N" limits have been applied. These settings can silently reduce the number of rows loaded without any warning. 

     

    3. Save as a .hyper file 

    Once the Extract is configured correctly, save it as a Tableau .hyper file. This format is optimized for performance and will allow Tableau to work with your full dataset efficiently. 

     

    4. If you are combining multiple years of DVF data 

    Consider using Tableau's built-in "Union" feature (drag a second CSV below the first in the Data Source tab) rather than manually merging files beforehand. This keeps your workflow clean and avoids file size issues. 

     

    Let me know if this helps.

Write an answer...
0/9000
Alice Carusi
May 9, 4:37 PM
Unable to open my complete file work. Probable error in saving the file

Good morning. I was looking for help on Tableau. Yesterday, I saved on my Mac an assignment for my online University course due tonight. It seems I can't open it back. Once I open it, it does not recognize the connection and asks to locate, remove, regenerate, or deactivate the extract. Once I click cancel or regenerate, my work is not there except for named sheets with no visuals. Any suggestions on how I should recover this assignment other than starting it back again? 

 

#Tableau Public

1 answer
  1. Dan Chissick (Naya Technologies)
    May 12, 5:26 AM

    Hi @Alice Carusi

     

    The problem is in the connection to the data, not your workbook itself. When connecting to files (Excel, csv, etc.) Tableau tends to create a "shadow copy" in a temporary folder, and that connection can get lost. 

    So edit your data source and edit the connection so it points to the original file again, and it will regenerate your extract. 

    Another tip: save your workbook as a .twbx file, and then the extract is contained inside and can't go missing. 

     

    Dan Chissick

    Senior BI Consultant | Tableau Ambassador 

Write an answer...
0/9000
Nathan Stafford (Business Intelligence Analyst at Texas Health Resources) asked in #Tableau APIs & Embedding
Jul 23, 2020, 2:14 PM
Embedded Dashboards in an Iframe Don't Show on Sharepoint on Chrome

I've embedded a dashboard on our SharePoint site using an iframe

 

  <iframe width="800" height="600" src="https: //TABLEAUSERVER/t/SITE/views/WORKBOOK/DASHBOARD?iframeSizedToWindow=true&amp;:embed=yes&amp;:showAppBanner=false&amp;:display_count=no&amp;:showVizHome=no&amp;:origin=viz_share_link&amp;:toolbar=no#7"></iframe> &#160;</div>

 

When using Chrome the dashboards don't show up at all. Looking at the developer console I see these errors. In IE they do show up fine.

 

Mixed Content: The page at 'https: //SHAREPOINTSITE/teams/TEAMSITE/SitePages/Tableau%20Challenge%20Page.aspx?PageView=Shared&InitialTabId=Ribbon.WebPartPage&VisibilityContext=WSSWebPartPage' was loaded over HTTPS, but requested an insecure frame 'http: //TABLEAUSERVER/vizportal/api/web/v1/auth/signin?path=%2Ft%2FSITE%2Fviews%2FWORKBOOK%2FDASHBOARD%3FiframeSizedToWindow%3Dtrue%26%3Aembed%3Dy%26%3AshowAppBanner%3Dfalse%26%3Adisplay_count%3Dno%26%3AshowVizHome%3Dno%26%3Aorigin%3Dviz_share_link&siteUrlName=THR-Tableau#1'. This request has been blocked; the content must be served over HTTPS.

 

and

 

Mixed Content: The page at'https: //SHAREPOINTSITE/teams/TEAMSITE/SitePages/Tableau%20Challenge%20Page.aspx?PageView=Shared&InitialTabId=Ribbon.WebPartPage&VisibilityContext=WSSWebPartPage' was loaded over HTTPS, but requested an insecure frame 'http: //TABLEAUSERVER/#/site/Tableau/views/WORKBOOK/DASHBOARD?'. This request has been blocked; the content must be served over HTTPS.

 

Me and a coworker were editing the page, changing settings and ocassionaly the dashboards will load, but we couldn't ever figure out exactly what we were doing to cause them to load in Chrome.

 

I talked to our server admin and he says they're using SSL, but I'm not sure why the addresses in the error messages are returning http instead of https. Is that a problem, and if so how can it be fixed?

 

Thanks,

1 answer
  1. Ilija Stojic (Toyota Motor North America)
    May 11, 3:54 PM

    This is most likely an issue with a reverse-proxy (if you're using one) or Tableau's CORS settings. Chrome is absolutely a pain (i.e., strict) with cross-origin resources. You can ask your admin to configure CORS and add SharePoint to your allowlist, but it seems like this problem keeps recurring with Chrome updates.

Write an answer...
0/9000