SharePoint 2010 PowerPivot Auto Refresh Does Not Work

Question

I’m using a SharePoint Unattended Account with the workbook's Excel Services set to None. Looking at the Date Refresh History in SharePoint all seems to be working fine; Date Refresh History says that update to the workbook Succeeded.  

After a Succeeded refresh I open the workbook in Excel and then open the PowerPivot window I’m finding that total record count is incorrect. For example in PowerPivot window there are 28,000 records, when I select Refresh in PowerPivot window it updates to 29,000.  Appears to me that SharePoint is going through all the motions correctly but the PowerPivot data in the workbook is not actually getting updated.

My simple thought is that SharePoint would open the workbook update the PowerPivot records to the current count and then close the workbook with the most current records. So my question is why when I open the workbook after a succeeded refresh how come the data isn’t actually updated?

Answer 1

Hi KarlRexx,

Thanks for your post.

In your case, you can refer to the following article about "Verify Data Refresh". Please see:
http://technet.microsoft.com/en-us/library/ee210651.aspx#drverify

For more information about Troubleshooting PowerPivot Data Refresh, please refer to the article below:
http://social.technet.microsoft.com/wiki/contents/articles/3870.troubleshooting-powerpivot-data-refresh.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support

Answer 2

Thanks for the reply Bin. I had read through most if not all the links above prior to submitting.

Here is another example. On the 25th I manually updated the Workbook connections and refreshed the data in the PowerPivot Window and recorded 72,798 records. Looking at the SharePoint Manage PowerPivot Data Refresh history; the auto refresh completed successfully 4 times with no error. On the 25th there were 72,798 records after a manual refresh of the data today; the record count changed to 72,949. I have 151 records that never got pulled into the reports?

From what I can see; this technology does not work. Also now starting to see a trend that when PowerPivot is refreshed manually using Excel’s connection manager; the data in PowerPivot Window does not update. Only after the PowerPivot Window is opened and Refresh is ran manually the new records are pulled in.

Any thoughts in these errors would be appreciated.

Answer 3

PowerPivot in Sharepoint will not auto update your information if you are using Excel as a data source. this is something i'm going though now. you can try this guys solution which did not work for me

http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/

but it might just do it for you

---

Noor