powerbi发布本地_PowerBI中本地数据的注意事项

powerbi发布本地

Whether you’ve been using PowerBI for a while or you’re just getting started with it, chances are you’ll want to source at least some of your data from on-premises systems. Be that SQL server databases, Oracle, SSAS etc. The same process even applies if you’re sourcing from AWS which I’ll go into in more detail below. All of these data sources will require Microsoft’s On-Premises Data Gateway.

无论您是使用PowerBI已有一段时间还是刚刚开始使用PowerBI，都有可能需要从本地系统中获取至少一些数据。 是SQL Server数据库，Oracle，SSAS等。如果您从AWS采购，则同样的过程同样适用，我将在下面更详细地介绍。 所有这些数据源都将需要Microsoft的本地数据网关 。

Originally branded the PowerBI Enterprise Gateway (in line with the other option of the “Personal Gateway” you could set up locally when creating a report in PowerBI Desktop). The product was later expanded to encompass several Azure services as shown in the handy diagram below.

最初是PowerBI企业网关的商标（与“个人网关”的其他选项一致，您可以在PowerBI Desktop中创建报表时在本地设置）。 稍后将产品扩展为包含几个Azure服务，如下图所示。

The On-Premises Data Gateway is an application which is installed within your network to give encrypted & compressed connectivity between Azure cloud services and your on-premises data.

本地数据网关是一个安装在网络中的应用程序，用于在Azure云服务与本地数据之间提供加密和压缩的连接。

The application itself can be installed on an existing or separate server/VM. The main performance considerations here are network throughput and uptime. The importance of these factors depends on your environment though.

该应用程序本身可以安装在现有或单独的服务器/ VM上。 这里主要的性能考虑因素是网络吞吐量和正常运行时间。 这些因素的重要性取决于您的环境。

I.e. The data gateway can be installed on a Windows 7 machine or higher (and further system requirements can be found at the documentation link in the first paragraph) but as you’d expect, as soon as this machine is powered off you lose all connectivity to your on-premises data sources in PowerBI.

即，数据网关可以安装在Windows 7或更高版本的计算机上（进一步的系统要求可以在第一段的文档链接中找到），但是正如您所期望的那样，在关闭计算机电源后，您将失去所有连接到PowerBI中的本地数据源。

I’ll go into more detail on high availability further on though as there’s no built-in solution at this time though the workaround in the Appendix is straight forward.

尽管附录中的解决方法很简单，但由于目前没有内置解决方案，因此我将进一步详细介绍高可用性。

许可限制 (Licensing restrictions)

Although the data gateway application itself is free to download and use, there are licensing considerations when using some functionality, such as Live/DirectQuery, specifically to Analysis Services which I’ve summarised below.

尽管数据网关应用程序本身可以免费下载和使用，但是在使用某些功能（例如Live / DirectQuery，特别是Analysis Services时，需要考虑许可问题），我在下面对此进行了总结。

A full list of data sources that can use Live/DirectQuery connections can be found here.

可以在此处找到可以使用Live / DirectQuery连接的数据源的完整列表。

With the recent announcement of PowerBI Premium licensing and changes to the Pro & Free tiers, DirectQuery data from SSAS is now considered a “Pro” feature & will require a Pro or premium license*. More details on the tier restrictions can be found here.

随着最近宣布的PowerBI Premium许可和对Pro＆Free层的更改，来自SSAS的DirectQuery数据现在被视为“ Pro”功能，并且需要Pro或Premium许可证*。 有关层级限制的更多详细信息，请参见此处 。

*I’ve added an asterisk here as I think this will change. Microsoft seems to have forgotten small/medium businesses with the new model. There is also talk of a revision of the licensing tiers in PowerBI. Looking at Power BI Ideas, some form of change is at least top of the “Hot Ideas” list!

*我在这里添加了一个星号，因为我认为这将会改变。 微软似乎已经忘记了使用新模型的中小型企业。 也有谈论修订PowerBI中的许可层。 从 Power BI Ideas 来看，某种形式的更改至少是“ Hot Ideas”列表的顶部！

认证方式 (Authentication)

When connecting to on-premises databases you’ll generally connect with your Windows AD account or some kind of SQL/Service account, depending on the actual source. The former gives you the use of AD group security, single sign-on & allowing you to tailor the permissions for different sets of users. I.e. Sales Teams, Finance, Management etc.

连接到本地数据库时，通常将连接Windows AD帐户或某种SQL / Service帐户，具体取决于实际来源。 前者使您可以使用AD组安全性，单点登录并允许您为不同的用户组定制权限。 即销售团队，财务，管理等。

Using the latter gives flat access to your data, with no per-user restrictions. That can however, be achieved by multiple service accounts for different business units, teams etc.

使用后者可以对您的数据进行统一访问，而不受每个用户的限制。 但是，可以通过针对不同业务部门，团队等的多个服务帐户来实现。

With the On-premises data gateway, you provide a static/service account to connect to each data source. This can be an AD account (if using Windows authentication method) or a service account as described above (using Basic authentication)

使用本地数据网关，您可以提供一个静态/服务帐户来连接到每个数据源。 这可以是AD帐户（如果使用Windows身份验证方法）或如上所述的服务帐户（使用基本身份验证）