外部数据刷新sharepopint 2013中的powerpivot图表失败 [英] External Data refresh Failed for powerpivot chart in sharepopint 2013
问题描述
大家好,
我已使用SharePoint列表的以下URL创建了功率枢纽图表和表格.
I have created power pivot chart and Table using below URL for the SharePoint list.
https://www.metrostarsystems.com/enterprise-it/sharepoint- list-dashboard-excel-viewer/
从工作簿设置自动刷新时,我收到以下错误消息.
I am receiving below error when I set the auto refresh from workbook.
有人可以在这里指导/帮助我
Can someone please guide/help me here
MercuryMan
MercuryMan
推荐答案
MercuryMan,
Hi MercuryMan ,
The SharePoint site is trying to access external data which may be not non to end user. The end user gets this warning message due to security.
1.转到SharePoint管理中心>应用程序管理
2.服务应用程序>管理服务应用程序> Excel Services应用程序>受信任的文件位置,然后单击包含工作簿的地址.
4.访问该工作簿的用户将不再显示警告对话框.
1. Go to SharePoint Central Administration > Application Management
2. Service Applications > Manage service applications > Excel Services application > Trusted File Locations and click on the Address that contains the workbook.
3. In the External Data section, under Warn on Refresh, uncheck Refresh warning enabled and click OK.
4. Users who access the workbook will no longer be presented with a warning dialog box.
Below blog also would be a solution :
https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/02/01/powerpivot-2013-for-sharepoint-external-data-refresh-failed-using-interactive-data-refresh-via-use-the-authenticated-users-account/ .
最好的问候
安东尼
这篇关于外部数据刷新sharepopint 2013中的powerpivot图表失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!