I am trying to create a data source that joins together 9-10 tables/views in a MySQL database.
When I add the 7th table to the data source, Tableau auto selects the table and field to join on. When I then modify the join to the correct field on a different table, the "Go to Worksheet" button becomes inactive and I am unable to update the dataset.
What am I doing wrong?
There's probably a problem with the join to that 7th table. Is it using the correct fields? Please post a picture of your data connection screen if you want more help.