sharepoint 2013 PowerPivot for SharePoint 2013 刷新数据时报错
来源:互联网 发布:代码编程 编辑:程序博客网 时间:2024/06/06 17:38
最近在做PowerPivot for sharepoint 2013的报表过程中,出现了下面的问题:
PivotTable Operation Failed An error occurred while working on the Data Model in the workbook.
数据透视表操作失败时发生了一个错误的工作在工作簿中的数据模型
PivotTable Operation Failed An error occurred while working on the Data Model in the workbook.
以及刷新文档库中的报表数据时,也出现了如下报错:
An error occurred while working on the Data Model in the workbook. Please try again.
We were unable to refresh one or more data connections in this workbook。
在工作簿中的数据模型时发生了一个错误。请再试一次。我们无法更新一个或多个工作簿中的数据连接
查了很多资料发现,原来是因为我在sharepoint server 2013 中,部署了office web apps 2013导致的,我们发现Excel Service 应用程序与Office Web Apps 2013的excel预览冲突。
解决的办法是在sharepoint server 2013服务器上,用管理员运行,打开sharepoint powershell,输入如下命令:
New-SPWOPISuppressionSetting -extension xlsx -action view
之后回车运行,然后再回到sharepoint文档库中,查看PowerPivot的报表,刷新后,一切正常。
- sharepoint 2013 PowerPivot for SharePoint 2013 刷新数据时报错
- 如何使用数据馈送 (PowerPivot for SharePoint)
- Install PowerPivot for SharePoint(SharePoint 2013来支持商业智能--Pivot)
- SharePoint 2013 BI--Power Query for SharePoint
- PowerPivot: SharePoint与Excel 在数据分析领域的配合
- Configure an environment for apps for SharePoint (SharePoint 2013)为 SharePoint 相关应用程序配置环境
- Turn off Mobile View for SharePoint 2010 and SharePoint 2013
- SharePoint 2010 vs SharePoint 2013
- sharepoint 2013 如何创建一个webservice获取sharepoint列表数据
- 如何在SharePoint 2013 创建Power pivot 库(How to create a PowerPivot Gallery )及错误解决方法
- SharePoint 2013 Foundation 报错: 试图调用服务应用程序时报告了失败: EndpointFailure 8313
- sharepoint 使用gantt view时报错
- sharepoint 2013 元数据导航设置
- SharePoint 2013 Designer系列之数据视图
- 在SharePoint 2013 中使用UpdatePanel控件进行局部刷新
- SharePoint 2013 app ---SharePoint hosted 实战(1)
- SharePoint 2013 IT Professional--SharePoint Group
- SharePoint Server 2013 之一:为SharePoint启航
- 杭电 1245
- 【PAT】1058. A+B in Hogwarts (20)
- java数据库编程
- as3.0正则表达式元字符$
- cookie&session
- sharepoint 2013 PowerPivot for SharePoint 2013 刷新数据时报错
- 深入关键词
- Linux netstat命令详解
- LOOPS(hdu3853,概率DP入门)
- Cenos 系统进不去 方法大全
- Fragment
- JAVA_WEB Struts2学习:Struts2常用标签
- 多校十Hdu 4704 Sum
- tty驱动详解