Sep 27 2019 09:42 AM
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.
Sep 27 2019 09:55 AM
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
Sep 27 2019 09:58 AM
This is a good article but does not fully automate the data pull.@Sergei Baklan
Sep 27 2019 10:10 AM
Power Query has no built-in connector to Tableau, thus only third party solutions like this.
Sep 27 2019 10:59 AM
Hi
If you created any visualization in Tableau, then
Right click that visualization
Select Copy Data
Paste it into Excel
Hope that helps
Nabil Mourad
Sep 27 2019 11:10 AM
Hi again,
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
Nabil Mourad
Sep 27 2019 12:10 PM
@nabilmourad I am trying to automate this process.
Oct 19 2023 08:07 AM
@Etronson I have researched this issue for a while and the only way to do this is through third-party software.