power bi数据分析_设置Power BI数据网关-优快云博客

power bi数据分析

In this article, I’m going to explain what a Power BI Data Gateway is and how to set it up. I’ll also cover the underlying architecture that the gateway uses and how to manage on-premise data using the Data Gateway.

在本文中，我将解释什么是Power BI Data Gateway以及如何设置它。我还将介绍网关使用的基础体系结构以及如何使用数据网关管理本地数据。

Please note that this article is not an introductory course to Power BI and assumes that you have a fair knowledge of working with Power BI Desktop as well as the Power BI service. (https://app.powerbi.com)

请注意，本文不是Power BI的入门课程，并且假定您具有使用Power BI Desktop和Power BI服务的丰富知识。 （ https://app.powerbi.com ）

The Power BI Data Gateway, as the name suggests, is a kind of gateway that acts as a connecting platform between the Power BI Cloud service and the on-premise datasets that are not on the cloud. For example, if you have set up your data sources on your local system or on a customer’s data center which is behind a firewall, you will need to install the Power BI Data Gateway for the Power BI Service to be able to connect to those data sources and fetch the data.

顾名思义，Power BI数据网关是一种网关，它充当Power BI Cloud服务与不在云上的内部部署数据集之间的连接平台。例如，如果您已在本地系统或防火墙后面的客户数据中心上设置了数据源，则需要安装Power BI Service的Power BI Data Gateway才能连接到这些数据源并获取数据。

The Power BI Data Gateway is not only limited for use by Power BI, but it can also be used by the other Azure cloud services like the Azure Analysis Services, Power Apps, Azure Logic Apps, and Power Automate. All these cloud services can use the same data gateway without any other specifications required.

Power BI数据网关不仅限于由Power BI使用，而且还可以由其他Azure云服务（如Azure Analysis Services，Power Apps，Azure Logic Apps和Power Automate）使用。所有这些云服务都可以使用同一数据网关，而无需任何其他规范。

数据网关架构 (Data Gateway Architecture)

As I have already mentioned, the Power BI Data Gateway is a kind of bridge between the on-premises data sources and the Power BI service available on the cloud. The gateway is a windows application that has to be installed on the same network as the other data sources are in. If you see the figure below, there are multiple steps that take place while querying through the data gateway. As you can see, there is also a clear distinction in the architecture between the cloud services and the on-premise data sources.

正如我已经提到的那样，Power BI数据网关是内部部署数据源和云上可用的Power BI服务之间的一种桥梁。网关是Windows应用程序，必须与其他数据源所在的网络安装在同一网络上。如果您看到下图，则在通过数据网关查询时需要执行多个步骤。如您所见，云服务和本地数据源之间的体系结构也有明显区别。

Let us now try to understand in a step-by-step manner, how the data processing is done using the data gateway.

现在，让我们尝试逐步了解如何使用数据网关完成数据处理。

Power BI Service, Power Automate or Azure Analysis Services etc. have the data model defined within them. This model also keeps the necessary queries that are required to Power BI Service ，Power Automate或Azure Analysis Services等任何云服务都在其中定义了数据模型。此模型还保留refresh the data 刷新数据所需的必要查询
encrypted by the Power BI Cloud Service 加密
Gateway Cloud Service 网关云服务
Azure Service Bus queue for further processing Azure Service Bus队列以进行进一步处理
It is the job of the Azure Service Bus to push the encrypted queries to the Application Gateway which is installed locally
Azure Service Bus的工作是将加密的查询推送到本地安装的Application Gateway
decrypts the source credentials and then connects to one or more 解密源凭据，然后连接到由连接字符串定义的一个或多个data sources as defined by the connection string 数据源
Application Gateway on the data source and the results are sent back 应用程序网关在数据源上执行查询，并将结果发送回
Power BI Cloud Service Power BI Cloud Servi