在PowerPivot上安排几个更新 [英] Schedule several updates on a PowerPivot

查看:127
本文介绍了在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:

https://smithicus.wordpress.com/2011/08/09/using-a-custom-data-refresh-schedule-in-powerpivot-for-sharepoint/

最诚挚的问候,


这篇关于在PowerPivot上安排几个更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆