IssueUnable to use data interpreter function when connecting to Google spread sheet from Tableau Prep Builder.
ResolutionPossible Workaround1. Download Google Spreadsheet and save as local Excel file.2. Connect to local Excel file from Tableau Prep Builder.
CauseData Interpreter function can only be used when connecting to Excel file from Tableau Prep Builder currently.Please check the following Tableau Prep Builder Online Help for more details."When working with Microsoft Excel files, you can use Data Interpreter to detect sub-tables in your data as well as remove extraneous information to help prepare your data for analysis."https://help.tableau.com/current/prep/en-us/prep_connect.htm#use-data-interpreter-to-clean-your-files
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.