power-pivot-data-refresh.md

title	PowerPivot Data Refresh | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
helpviewer_keywords	unattended data refresh [Analysis Services with SharePoint] scheduled data refresh [Analysis Services with SharePoint] data refresh [Analysis Services with SharePoint]
ms.assetid	ac8358a3-ee71-44c7-8ee6-ac7afe3ebaa4
author	minewiskan
ms.author	owend
manager	craigg

PowerPivot Data Refresh

After you create a workbook that contains PowerPivot data, you might want to periodically refresh the data by rerunning a query or command to get updated information from the sources you used originally to create the workbook. This process is called data refresh, and you can refresh data on demand in [!INCLUDEssGeminiClient], or as a scheduled operation that runs as an [!INCLUDEssASnoversion] process on an application server in a SharePoint farm. For more information, see:

• PowerPivot Data Refresh with SharePoint 2010

• Configure the PowerPivot Unattended Data Refresh Account (PowerPivot for SharePoint)

• Configure Stored Credentials for PowerPivot Data Refresh (PowerPivot for SharePoint)

• Schedule a Data Refresh (PowerPivot for SharePoint)

• View Data Refresh History (PowerPivot for SharePoint)

Note

[!INCLUDEssCurrent] and SharePoint Server 2013 Excel Services use a different architecture for data refresh of PowerPivot data models. The SharePoint 2013 supported architecture utilizes Excel Services as the primary component to load PowerPivot data models. The previous data refresh architecture used relied on a server running PowerPivot System Service and [!INCLUDEssASnoversion] in SharePoint mode to load data models. For more information, see the following:

• PowerPivot Data Refresh with SharePoint 2013
• Upgrade Workbooks and Scheduled Data Refresh (SharePoint 2013)