Cloud PowerPivot Data Refresh Options
Workbook Publishing Sites — No Automatic Refresh
- Least expensive Cloud PowerPivot option overall.
- Author and refresh workbooks on your desktop, then upload to your PowerPivot site.
- Re-upload new workbook versions as often as you wish.
- Get started with a 30-day free trial!
Workbook Publishing Sites Diagram
Automatic Refresh Sites
- Includes all the features of Workbook Publishing Sites.
- Plus, your workbooks refresh automatically and always reflect the latest data. No human intervention required.
- Several “data plumbing” options are available for connecting your workbooks back to their original data sources.
The two most popular automatic refresh options are:
Automatic Refresh A — Direct Refresh
- Least expensive auto refresh option.
- We create a Virtual Private Network (VPN) connection to your PowerPivot data source(s) on your existing corporate network.
- You author your workbook on your desktops against those data sources, then upload them to your PowerPivot site.
- Your workbooks automatically pull the latest data from the data sources on your network, on a schedule you specify.
Automatic Refresh A — Direct Refresh Diagram
Automatic Refresh B — Database Mirroring
- Best option for updating larger quantities of data, such as those exceeding 25 Million rows.
- We create a VPN connection to replicate your SQL Server* database to a private “mirror” database in our hosting environment.
This “mirror” database automatically stays up to date with the contents of the original database(s) on your own network.
- We provide you with one or more authoring workstations in our hosting environment to create your PowerPivot workbooks.
- Your workbooks automatically refresh against your “mirror” database in our hosting environment.
Automatic Refresh B — Database Mirroring Refresh Diagram
Regardless of which refresh option suits you, you can get started with a 30-Day FREE Trial of the Cloud PowerPivot Workbook Publishing Sites option to try out the service and upgrade to your preferred refresh option after your trial.