为什么Excel比Power Apps需要更少的信息来查询SQL Server？
在Excel 365桌面中，我可以：
- 打开一个空白的工作簿
- 单击“数据”功能区
- 单击“获取数据”，
- 从数据库中单击“
- 单击” SQL Server数据库'
- 填充“ Server”字段
- 单击“确定”
，这就是我的所有内容需要查询我的SQL Server。相反，在Web版本的Power Apps中，看来我绝对必须设置一种称为“网关”（或有时是“本地数据网关”）的东西。这似乎是不平凡的，看起来甚至可能花钱。
该限制有任何技术原因吗？我发现Excel似乎比Power Apps更强大，这非常令人惊讶。我在某种程度上深知吗？
In Excel 365 desktop, I can:
- Open a blank workbook
- Click on the 'Data' ribbon
- Click 'Get Data'
- Click 'From Database'
- Click 'From SQL Server Database'
- Fill in the 'Server' field
- Click OK
and that's all that I need to query my SQL server. Conversely, in the web version of Power Apps, it appears that I absolutely must set up something called a "gateway" (or sometimes, an "on-premises data gateway"). This appears to be non-trivial and looks like it may even cost money.
Is there any technical reason for this restriction? I find it very surprising that Excel appears to be more powerful than Power Apps. Am I profoundly ignorant in some way?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
要回答您的最后一个问题：是的，但是可以更改。
PowerApps是云服务。它托管在Microsoft服务器上。您可以查询各种数据，但是您需要所谓的“连接器”才能做到这一点。
如果数据源位于公司的内部网络上，则需要一种安全，安全地连接到该内部数据的方法。您不想将公司的SQL Server数据公开以供全世界查看。
要从诸如PowerApps（或Power BI或Power Automate）之类的云托管服务创建安全连接，您可以在内部网络中的机器上安装数据网关。然后，该网关是从云托管系统到公司的SQL Server或其他本地数据的网关。
如果您的SQL Server数据库托管在云中，例如在Azure中，那么您将不需要网关，并且可以在针对Azure托管的SQL的PowerApp中使用其他连接器。
To answer your last question: Yes, but that can be changed.
PowerApps is a cloud service. It is hosted on Microsoft servers. You can query all kinds of data, but you need so-called "connectors" to do that.
If the data source is on your company's internal network, then you need a way to connect to that internal data securely and safely. You wouldn't want to expose your company's SQL Server data for all the world to see.
To create that secure connection from a cloud-hosted service like PowerApps (or Power BI, or Power Automate), you install the data gateway on a machine in your internal network. That gateway is then the, ehm... , gateway from the cloud-hosted system into your company's SQL Server or other on-premises data.
If your SQL Server database is hosted in the cloud, for e.g. in Azure, then you would not need the gateway and could use a different connector in PowerApps that targets Azure hosted SQL.