在PowerPivot上安排几个更新 [英] Schedule several updates on a PowerPivot
问题描述
我的客户来找我,要求每天为其动力支点Excel进行一次以上的更新.
My customer came to me with a request about having more than one update per day for one of its power pivot Excel.
当前,此Power Pivot每天在00:00进行一次更新,但现在他希望在01:00 AM,05:00 AM和12:00进行更新.
Currently this Power Pivot is being updated once a day at 00:00, but now he wants at 01:00 AM, 05:00 AM and 12:00.
是否可以为一个Power Pivot设置多个时间表?如果没有解决方法,除了明显的手动刷新之外?
Is it possible to setup several schedules for one Power Pivot? If not is there a workaround, besides of the obvious manual Refresh?
预先感谢
Hugo Salgado
Hugo Salgado
推荐答案
Hugo
默认情况下,至少每天在SharePoint GUI中配置PowerPivot数据刷新计划.
It’s by default that configure PowerPivot data refresh schedule at least at daily level in SharePoint GUI.
以下是创建自定义数据刷新计划的一种解决方法,供您参考:
Here is a workaround to create custom data refresh schedule for your reference:
最诚挚的问候,
这篇关于在PowerPivot上安排几个更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!