Using PowerPivot for SharePoint 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 197

4. Select the Enable check box to make the page active so that you can fill in the values that you
want to use.

The Manage Data Refresh page is organized into six sections. Table 7-1 presents an overview of
each section, and detailed descriptions are given in the subsections that follow.

TABLE 7-1 Manage Data Refresh page sections

Section General description

Data Refresh Enable or disable a data refresh schedule.

Schedule Details Define the frequency and timing details of a data refresh.

Earliest Start Time Specify the earliest start time for a data refresh.
E-mail Notifications Specify the e-mail address of the users to be notified in the event of data refresh failures.
Credentials Provide the credentials that will be used to refresh data on your behalf.

Data Sources Select which data sources should be automatically refreshed. You also use this section to create

custom schedules that vary for each data source, or specify different authentication methods
for each data source.

data refresh
To enable or disable a data refresh schedule, select or clear the Enable check box on the Manage Data
Refresh page. If this check box is selected, you can edit all parts of the data refresh schedule. If the
check box is cleared, the page is read-only, and after you click OK, subsequent data refresh opera-
tions are disabled for that workbook.

Schedule details
In the Schedule Details section, you can specify the frequency and timing details of the data refresh.
There are four options from which to choose:

Daily

■

Weekly

■

Monthly

■

Once

■

With the Daily option (see Figure 7-8), you can schedule data refresh to occur every n day(s), every
weekday, or on specific days of the week.