SharePoint 2013-Excel Services-参数化的SQL查询? [英] SharePoint 2013 - Excel Services - Parameterized SQL queries ?

问题描述

Excel 2016/SQL Server 2014 +/SharePoint 2013-最新的SP/CU(2018年1月CU)

Excel 2016 / SQL Server 2014+ / SharePoint 2013 - Latest SP/CU (January 2018 CU)

我如何在SharePoint 2013中使用Excel 2016/Excel Services/Excel Web Access实施参数化的SQL查询?

How can I implement a parameterized SQL query using Excel 2016 / Excel Services / Excel Web Access in SharePoint 2013?

一些事实:
Excel Services支持的数据源==> https://technet.microsoft.com/zh-CN/library/jj819452(v=office.16).aspx

Some facts:
Data Sources supported in Excel Services ==> https://technet.microsoft.com/en-us/library/jj819452(v=office.16).aspx

Excel Services支持的外部数据连接:
+ SQL Server表
+ SQL Server Analysis Services多维数据集
+ OLE DB和ODBC数据源

External data connections supported in Excel Services:
+ SQL Server tables
+ SQL Server Analysis Services cubes
+ OLE DB and ODBC data Sources

Excel 2016 1)获取外部数据>来自其他来源>从SQL Server ...
Excel服务中支持SQL + 2014 +查询:-)
Provider = SQLOLEDB.1不支持参数化查询:-(

Excel 20161) Get External Data > From Other Sources > From SQL Server ...
SQL 2014+ query is supported in Excel services :-)
Provider=SQLOLEDB.1 does not support parameterized queries :-(

2)获取外部数据>来自其他来源>来自Microsoft Query ......
我认为由于提供程序= SQL Server，因此支持SQL + 2014 +查询
但是我收到此警告消息:"我们无法刷新此工作簿中的一个或多个数据连接.以下连接刷新失败:... ".  甚至在SQL查询中没有WITH&s参数:-(

2) Get External Data > From Other Sources > From Microsoft Query ...
I think SQL 2014+ query is supported due to provider = SQL Server
But I got this warning message: "We are unable to refresh one or more data connections in this workbook. The following connections failed to refresh: ...".  Even WITHOUT parameter(s) in the SQL query :-(

3)获取&转换>新查询>来自数据库>从SQL Server数据库...
由于提供程序= Microsoft.Mashup.OleDB.1，可能不支持SQL查询:-(

3) Get & Transform > New Query > From database > From SQL Server-database ...
SQL query is probapbly not supported due to provider = Microsoft.Mashup.OleDB.1 :-(

4)获取&转换>新查询>来自数据库>从ODBC ...
由于提供程序= Microsoft.Mashup.OleDB.1，可能不支持SQL查询:-(

4) Get & Transform > New Query > From database > From ODBC ...
SQL query is probably not supported due to provider = Microsoft.Mashup.OleDB.1 :-(

如果我们不能使用参数化查询，我认为Excel Services/Excel Web Access几乎没有用.

In my opinion Excel Services / Excel Web Access is almost useless if we can't use parameterized queries.

任何人都有很好的建议

推荐答案

"在我看来，如果我们不能使用[功能，则Excel Services/Excel Web Access几乎是无用的. X] ..."
你会失望的.

"In my opinion Excel Services / Excel Web Access is almost useless if we can't use [Feature X] ... "
You're going to have a llfetime of let down.

只需使用Excel Client应用程序来构建您梦想中的电子表格，然后使用Excel Services Web部件显示它. (也不要对此期望太大.)

Just use the Excel Client application to build the Spreadsheet of your dreams, and use the Excel Services Web Part to display it. (Just don't expect too much from that, either.)

这篇关于SharePoint 2013-Excel Services-参数化的SQL查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！