Interested to Buy Any Domain ? << Click Here >> for more details...
Can we place an excel file in a shared location and use it to develop a report and refresh it at regular intervals?
- 1 Answers
- 1938 Views
- I also Faced
- E-Mail Answers
Answer Posted / priyanka akadi
Yes, you can place an Excel file in a shared location and use it to develop a report in Tableau, and then schedule the report to refresh at regular intervals.
To do this, you would first need to connect to the Excel file as a data source in Tableau, either by selecting "Excel" as the data source type and selecting the file, or by selecting "Connect to Data" and browsing to the file location. Once connected, you can develop your report in Tableau using the Excel data source.
Next, you can set up a refresh schedule for the report by creating a Tableau Data Source Extract (.tde) file and publishing it to Tableau Server or Tableau Online. When you publish the .tde file, you can set up a refresh schedule for the data source, such as daily, weekly, or monthly.
Alternatively, if you have Tableau Desktop Professional or higher, you can use Tableau's "Scheduled Refresh" feature to schedule the report to refresh at regular intervals without having to publish it to Tableau Server or Online. To do this, go to the "Data" menu, select "Scheduled Refresh", and set up the refresh schedule for the Excel data source.
Note that in order to refresh the data in the Excel file, the file must be accessible from the location where the report is being refreshed, and the credentials used to access the file must be valid at the time of refresh. Additionally, any changes to the data structure or schema in the Excel file may require updates to the Tableau report in order for it to refresh correctly.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the major differences between tableau version 7.0 and tableau version 8.0?
How do you normalize data for use in tableau?
What are the differences between Tableau desktop and Tableau Server?
What are the features of tableau 8.3?
What is the difference between a tree map and heat map?
What is the distinction between connection and mixing in tableau?
Think that I am using tableau desktop & have a live connection to cloudera hadoop data. I need to press f5 to refresh the visualization. Is there anyway to automatically refresh visualization every ‘x’ seconds instead of pressing f5?
Define parameters in tableau and their working?
Suppose my license expires today, can users able to view the dashboards or workbook which I published in server earlier?
What is a tableau data server?
What is a hierarchy in tableau?
What is the tableau servers?
Explain the features of tableau?
Can you get values from two different sources as a single input into parameter?
What are the aggregation and disaggregation?
