Is there a way to use Excel's Get Data function to connect to a Tableau server workbook to pull data into an Excel workbook? I do not want to manually export from Tableau into Excel.
I have no practical experience, but check this post https://www.linkedin.com/pulse/tableau-server-data-source-details-using-power-bi-excel-rob-reilly/ if helps
This is a good article but does not fully automate the data pull.@Sergei Baklan
Power Query has no built-in connector to Tableau, thus only third party solutions like this.
If you created any visualization in Tableau, then
Right click that visualization
Select Copy Data
Paste it into Excel
Hope that helps
If you did not create any visualization you can click on the "Data" Menu at the Top
From the drop menu select the Last option (Changes according to the Tableau File active) >>
From the Submenu >>
Select Vie Data >>
A window will open showing all the Source Data >>
In the Upper Right corner of this window >>
Click "Export ALL" >>
This will give you the option to Export to a .CSV file which can be opened in Excel
Hope That Helps
@nabilmourad I am trying to automate this process.