legacy connection in excel file in tableau on mac

Save changes to the Excel file, then refresh the extract in Tableau Desktop to pull in new data.Save the workbook, close and then reopen Tableau Desktop.Option 2: Use an Extract Connection to the Excel File Resolution Option 1: Continue to Use Native Connection (Tableau Desktop only)Ĭlose Tableau Desktop and then save the Excel file. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.Your changes could not be saved to '’ because of a sharing violation. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. IMPORTANT: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection.

For Excel and text file data sources, this option is available only in workbooks that were created before Tableau Desktop 8.2 or when using Tableau Desktop on Windows with the legacy connection. In the Open dialog box, click the Open drop-down menu, and then select Open with Legacy ConnectionĪdditional information Note: The Convert to Custom SQL option may be greyed out or missing if the data source does not support a SQL connection, or if there is a cross-database join in the canvas area.Connect to Excel with the legacy data connector.Navigate to Data > Convert to Custom SQL.Optional: Drag additional tables into the canvas area to create joins.Drag at least one table into the canvas area.(See IMPORTANT note in Additional Information)Īnswer Option 1: When connecting to data sources that support SQL connections QuestionHow to convert a connection to a table or joined tables into a custom SQL query in Tableau DesktopĮnvironmentTableau Desktop earlier than 2019.1.

Legacy connection in excel file in tableau on mac