Wednesday, September 28, 2011 9:59 AMHi, We have SP2010 farm and deployed all features of it. We have some reports to be displayed to our customers with current data. We are able to refresh powerpivot data twice in a day. We required to shcedule atleast every 15 min
Friday, September 30, 2011 8:02 AMModerator
Hi Girish Dixit,
Currently, daily is the most frequent interval available for data refresh. There is a post on the PowerPivot team blog that addresses data refresh and can be found here:http://blogs.msdn.com/b/powerpivot/archive/2009/11/20/powerpivot-data-refresh.aspx.
Below are explanation quoted from PowerPivot product team about date refershment for powerpivot:
Finally, we wouldn’t be honest if we said that the data refresh facility was the right solution for everyone. Clearly it isn’t. It is oriented to you, the end user; not to your IT colleagues. As a scheduler, it lacks many of characteristics that IT systems typically have. For example, there is no real-time or on-demand access to data; or the ability to issue frequent updates, such as hourly or every 5-10 minutes. These capabilities are important in their own way, and some systems demand them, but in the managed self-service world they come with a management overhead and complexity that is just not appropriate for our users.
I hope this helps.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.