Sharepoint Excel Web Access [英] Sharepoint Excel Web Access

问题描述

下午好，我正在尝试使用Excel Web Access Webpart将Excel(xlsx)文件放在sharepoint 2013页面上.此xlsx具有通过获取外部数据连接的excel文件(csv).问题是当我尝试刷新连接并返回时 错误:工作簿的数据模型中存在错误.再试一次.我们无法更新工作簿中的一个或多个数据连接.更新以下连接失败:查询-mds我该怎么办才能解决问题?

Good afternoon, I'm trying to put an Excel (xlsx) file on a sharepoint 2013 page using the Excel Web Access webpart. This xlsx has an excel file (csv) connected through get external data. The problem is when I try to refresh the connection and it returns the error: There was an error working in the Data Model in the workbook. Try again. We were unable to update one or more data connections in the workbook. Updating the following connections failed: Query - mds What can I do to solve the problem?

推荐答案

您好，HugoAMPereira，

Hi HugoAMPereira,

您是如何添加外部数据源的?

How did you added the external data source?

Excel Services不支持您可以在Excel中使用的所有数据连接.

Not all of the data connections that you can use in Excel are supported in Excel Services.

请参阅以下有关Excel Services(SharePoint Server 2013)支持的数据源的文章:

Refer to the following article about data sources supported in Excel Services (SharePoint Server 2013):

https://technet.microsoft.com/en-us/library/jj819452.aspx?f = 255& MSPPError = -2147217396

最好的问候

Lisa Chen

Lisa Chen

这篇关于Sharepoint Excel Web Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！