About Reloading a Dataset's Data
You can reload data in a dataset to keep it up-to-date.
Reloading data ensures that workbooks and visualizations contain current data. The most current data is displayed in workbooks and visualizations after the dataset reload is complete and you refresh the workbooks. See Refresh a Workbook's Data.
How you reload a dataset depends on how the data is sourced.
| Dataset Source Type | How You Reload Data |
|---|---|
| Data from databases that support incremental loading |
You can reload dataset data incrementally if the dataset uses a data source that supports this. Incremental loading only loads new or updated data. See Reload a Dataset's Data Incrementally. |
| Data from external connections | When you reload data for a dataset with an external connection, the dataset's
SQL statement is rerun and the current data for the tables with the
Data Access field set to
Automatic Caching is loaded into cache.
If your dataset contains one or more tables with the Data Access field set to Automatic Caching, then you can use the Data page to reload the tables in the dataset. |
| Data from Excel, CSV, or TXT File | When you reload a Microsoft Excel file (XLSX or XLS), the newer spreadsheet file
must contain a sheet with the same name as the original file. And
the sheet must contain the same columns that are in the dataset. The
data reload fails if the file you load is missing
columns.
When you reload a CSV or TXT file, it must contain the same columns that are in the dataset. A reload will fail if the file you load is missing columns. To reload a dataset that uses one file as its source, use the Data. |
| Data from Oracle Fusion Cloud Applications Suite |
You can reload data and metadata for Fusion Applications Suite data sources. If the Fusion Applications Suite data source uses logical SQL, reloading data reruns the dataset's SQL statement. |