SharePoint PowerPivot refresh frequency

Hi,

Is it possible to change the refresh frequency to be more often than once a day? It seems that's the most frequent data refresh setting possible.

Thanks,

Kosta

September 19th, 2013 5:46pm

Yes, there is. You can set the frequency to more than once a day. 

"...would like the data refresh request to be added to a process queue. You specify minutes in 15-minute intervals."

http://technet.microsoft.com/en-us/library/gg413467.aspx

Free Windows Admin Tool Kit Click here and download it now
September 19th, 2013 6:20pm

Hi Kosta,

I'm afraid that we can only configure PowerPivot data refresh schedule at daily level in SharePoint GUI. But, we have  workaround to deal with this issue.

Please see a similar thread about this topic:
PowerPivot Hourly Data Refresh on SharePoint: http://social.msdn.microsoft.com/Forums/en-US/8c267832-b101-43ec-a420-87ca45f90c9a/powerpivot-hourly-data-refresh-on-sharepoint

Regards,

September 25th, 2013 1:08pm

Thank you Elvis!
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2013 5:54pm

Paras - that's not the frequency - it's the time of day that the daily run starts. 
March 13th, 2014 12:30am

Thanks for pointing this out!

sorry for misinterpreting.

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2014 6:42pm

There is also a third party tool to facilitate this workaround capability:

PowerPivotPro's Power Update tool:

http://www.powerpivotpro.com/2015/02/introducing-power-update/

March 6th, 2015 12:33pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics