Export (0) Print
Expand All

Power Pivot Data Refresh

 

After you create a workbook that contains Power Pivot 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 Power Pivot for Excel, or as a scheduled operation that runs as an Analysis Services process on an application server in a SharePoint farm. For more information, see:

System_CAPS_noteNote

SQL Server 2016 and SharePoint Server 2013 Excel Services use a different architecture for data refresh of Power Pivot data models. The SharePoint 2013 supported architecture utilizes Excel Services as the primary component to load Power Pivot data models. The previous data refresh architecture used relied on a server running Power Pivot System Service and Analysis Services in SharePoint mode to load data models. For more information, see the following:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft