Issue
Unable to use data interpreter function when connecting to Google spread sheet from Tableau Prep Builder.
Last Modified Date: 08 Jul 2022
Environment
- Tableau Prep Builder
- Google Sheets
Resolution
Possible Workaround1. Download Google Spreadsheet and save as local Excel file.
2. Connect to local Excel file from Tableau Prep Builder.
Cause
Data 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
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials