Tableau and SmartSheet Reports (Size Limitation?)

Kevin Loo

I am trying to use Tableau to visualize a SmartSheet report.  The SmartSheet report is an aggregate of 5 to 10 other SmartSheets with a total number of 1500 rows.

 

Initially, I am able to successfully access the SmartSheet report with a limited number of sheets in the report and visualize it with Tableau.  However, as I aggregate additional SmartSheets into the report (less than 10),  I encounter the error message, "An error occurred while communicating with the data source.  Unable to connect to the server.  Check that the server is running and that you have access privileges to the requested database."  I know the server is running and I have access to the database.

 

I noticed that Tableau can handle the data if I export the SmartSheet report to excel and have Tableau access it that way.

 

Am I encountering some type of limitation or restriction between Tableau and SmartSheet?

 

Please help.

Kennedy Stomps

Hi Kevin-- I haven't encountered this error before! Can you reach out to our Support team at Support@Smartsheet.com about this? Please include a screen capture of the error message and outline any troubleshooting steps you may have tried. Let me know if you don't hear back from someone after submitting your ticket and I'll be happy to follow up on your behalf!

Sara_H

Hi Kennedy, I am experiencing a similar issue where I can connect to an individual smartsheet but not to a report aggregating several smartsheets.  I have just sent in a support ticket.

Kennedy Stomps

Hi Sara-- Thanks for letting me know. Have you heard back yet from the Support Team? If not, let me know and I'll follow up on that for you

Kevin Loo

I will reach out to support.  Thanks.