Publishing Your BI Tools to SharePoint - Microsoft Business Intelligence Tools for Excel Analysts - page 296

Figure 15-5: A Power Pivot Gallery.
You can manually refresh the data connections within your published Power Pivot report by opening
the workbook and selecting the Data drop-down menu, as shown in Figure 15-6. You have the option
of refreshing a single selected connection or all connections in the workbook.
Figure 15-6: Use the Data drop-down menu to manually refresh data connections.
If you don't want to go through the trouble to manually refresh your connections, you can set a
schedule. Click the Manage Data icon in the upper right-hand corner of the target report (see
Figure 15-7).
SharePoint opens the Manage Data Refresh window shown in Figure 15-8. The idea is to configure
each setting to achieve the desired refresh schedule.
➤ Data Refresh: The Data Refresh setting is the On/Off switch for your schedule. Select the
Enable check box to make the schedule active. Deselect the check box to stop automatic
refreshes.
➤ Schedule Details: The Schedule Details section allows you to specify the frequency and
intervals of your schedule. In addition to selecting your time intervals, you have the option to
refresh as soon as possible. Selecting this option starts a refresh within a minute, letting you
test your refresh process and ensure that it runs properly.