Saturday, July 14, 2012 4:28 PM
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?
Saturday, July 21, 2012 6:46 AMModerator
Thanks for your post.
In your case, you can refer to the following article about "Verify Data Refresh". Please see:
For more information about Troubleshooting PowerPivot Data Refresh, please refer to the article below:
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, July 23, 2012 11:11 AM
Sunday, July 29, 2012 3:19 PM
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.
Tuesday, November 20, 2012 10:57 PM
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
but it might just do it for you