Data Refresh View
The Data Refresh view shows the progress of refresh operations on the server. A refresh you start from the TOM Explorer appears in the view as an active refresh.
Refreshes run in the background while you keep editing the model, and an error message appears if a refresh fails.
Data Refresh view columns
Each refresh operation has these columns:
- Object: the model object being refreshed (table, partition or model).
- Description: details about the refresh operation and its current state.
- Progress: the number of rows imported so far.
- Start Time: the date and time the operation began.
- Duration: the elapsed time since the operation began, updated live for active operations.
Sorting refresh operations
Click a column header to sort by that column: once for ascending, again for descending. For example:
- sort by Start Time, descending, to list the latest refresh operations first
- sort by Duration to find long-running operations
- sort by Object to group refreshes by table or partition name
Note
All the messages and durations shown in the Data Refresh window are estimates only. Tabular Editor listens to trace events from SSAS during processing. SSAS is not guaranteed to send all trace messages to the client (for example it may throttle the trace event notifications during times of peak CPU/memory consumption).
Tip
If you need accurate and reliable information about refresh progress and durations, you should connect SQL Server Profiler to your SSAS instance, and collect the information manually during processing.