About Reloading a Dataset's Data

You can reload a dataset that uses one file as its source, when one or more tables in the dataset are cached, or when the dataset is created from running a data flow. Or you can reload a datasets's files and tables individually.

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 data depends on the dataset's data source type.

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. To reload individual tables, use the Dataset editor. You can also set up a schedule to reload your dataset's tables as often as once per hour. See Schedule a Dataset Reload.

Reload Excel, CSV, or TXT File

When you reload a Microsoft Excel file (XLSX or XLS), you must ensure that the newer spreadsheet file contains 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, make sure that it contains the same columns that are in the dataset. A reload will fail if the file you load is missing columns.

Scheduling a reload isn't available for datasets that contain only Excel, CSV, or TXT files.

To reload a dataset that uses one file as its source, use the Data page or Dataset editor. If a dataset uses two or more files, then use the Dataset editor to manually reload each file. If a dataset uses a combination of files and external connections, then use the Dataset editor to manually reload each file.

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.