Wednesday, June 06, 2012 12:30 PM
hi - i have set up PowerPivot for SharePoint but can't data refresh to work properly. The install guide mentions to use Microsoft Access Database Engine 2010 to schedule data refresh for workbooks that have Microsoft Access or Excel as their data source. Do I install this on the SharePoint WFE or on the SQL database server? I can't seem to find any documentation on it out there.
Tuesday, June 12, 2012 9:58 AMI would install it in the WFE Server (where your SharePoint services are running).
Thursday, June 14, 2012 8:27 AMModerator
Please refer to the following articles about enabming and configuring PowerPivot Data Refresh:
PowerPivot Data Refresh:http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/b111e250-43cf-42f4-ad6e-0022c866eab5
Enable and Configure PowerPivot Data Refresh: http://msdn.microsoft.com/en-us/library/ee210595.aspx
Configure Stored Credentials for PowerPivot Data Refresh: http://msdn.microsoft.com/en-us/library/ee210595.aspx
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Sunday, June 17, 2012 10:30 AM