Hi Rush, using the global-superstore.xlsx file works for me with Tableau Public. What are the steps you're taking with this file that causes the error?
Hi Jeff, thank you for the quick response.
I use the "Connect to a file" option, then select "Microsoft Excel"
I've tried using the legacy connection method but got the same result. I have also tried simply dragging and dropping into Tableau but got the error again.
May I ask what method you used? Perhaps I am missing something.
1 of 1 people found this helpful
Hi Rush, I have no problem opening global-superstore.xlsx (via Connect to File > Excel). Please list all the steps you're taking, until you see a problem -- and if the first problem isn't the red exclamation mark, then provide details on that.
Two more things:
1) The error message says to edit the datasource. Have you tried that? Does anything seem wrong with the information displayed?
2) If you haven't already done so, update to the latest version of Tableau Public.
I've been seeing this problem pretty often over the past two weeks with new datasets I've imported into TableauPublic. Last night, every dataset was resulting in the error--even one with two rows and fifty columns. TINY.
I thought the problem might be related to how my Excel spreadsheets were being encoded, so I tried opening a Googlesheet. Same error.
I was able to overcome it if--the moment after connecting to the data--I first dragged the data tab onto the canvas and THEN created a new worksheet. If I imported the data and then used the data interpreter, or then created a worksheet, the problem recurred.
I should point out that a few days ago I deleted Tableau and reinstalled it, but that had no impact on the error. It was still there after the reinstall.