本地数据网关(个人模型)On-premises data gateway (personal mode)

可以通过网关使用本地数据源以及创建 Power BI 报表和仪表板。You can use on-premises data sources, and create Power BI reports and dashboards, using a gateway. 网关是一种软件,不仅有助于用户访问存储在专用、本地网络的数据,还使用户能够使用联机服务(如 Power BI 服务)中的数据。A gateway is software that facilitates access to data that is stored on a private, on-premises network, then enables you to use that data in online services like the Power BI service. “本地数据网关(个人模式)”是最新发布的对 Power BI Gateway 的更新,它允许个人在自己的计算机上安装网关并获取对本地数据的访问权限。The on-premises data gateway (personal mode) is a recently released update to the Power BI gateway that allows individuals to install a gateway on their own computer, and gain access to on-premises data.

备注

“本地数据网关(个人模式)”将替代之前支持的个人网关版本(称为“Power BI Gateway - Personal”)。The on-premises data gateway (personal mode) replaces the previously supported version of the personal gateway, which is called Power BI Gateway - Personal. 以前的个人网关仅可在 2017 年 7 月 31 日之前可用。The previous personal gateway will continue working only until July 31, 2017. 请参阅以下部分,了解有关如何更新到新版本的信息。See the sections below for information on how to update to the new version.

本地数据网关(个人模式)的功能Features of the on-premises data gateway (personal mode)

随着“本地数据网关(个人模式)”的发布,将提供一系列改进和功能。With the release of the on-premises data gateway (personal mode), a collection of improvements and features are now available. 以前版本的个人网关(名为“Power BI 网关 - 个人版”)在实现时存在一些限制。In the previous version of the personal gateway (which is called Power BI Gateway - Personal), its implementation imposed some limitations. 与许多 Power BI 产品一样,我们了解了客户需求、诉求及其使用产品的方式。As with many Power BI products, we listened to customer needs, requests, and how they used the product. 因此,“本地数据网关(个人模式)”经过完全重新设计,现包括以下功能和改进:As a result, the on-premises data gateway (personal mode) has been redesigned from the ground up, and includes the following features and improvements:

  • 可靠性提高 - 新版个人网关改进了代码和结构化软件,因而比以前的版本可靠性更高。Improved reliability - the new version of the personal gateway has improved reliability over the previous version, due to code and structural software improvements.
  • 扩展性增强 - 发布其他功能时,可将其轻松添加到个人网关,从而改进结构化软件。Enhanced extensibility - as part of the structural software improvements, additional features can easily be added to the personal gateway as they become available.
  • 从 Power BI 服务中删除个人网关 - 在新版本中,用户现在可以删除 Power BI 服务内的个人网关。Delete personal gateway from the Power BI service - with the new version, you can now delete your personal gateway from within the Power BI service.
  • 配置和服务日志 - 在新版本中,用户仅需单击即可将配置和服务日志轻松导出到 .zip 文件。Configuration and service logs - the new version lets you easily export configuration and service logs to a .zip file, with a single click.

安装本地数据网关(个人模式)Installing on-premises data gateway (personal mode)

若要在未安装以前版本网关的情况下安装本地数据网关(个人模式),请选择“Power BI 服务”中的齿轮图标,然后选择“数据网关”。To install the on-premises data gateway (personal mode) without having the previous version of the gateway installed, select the gear icon in the Power BI service and select Data Gateway.

也可以从此位置下载网关。You can also download the gateway from this location. 可以按照安装步骤进行安装,由于安装过程允许安装任一网关版本(可与他人共享的标准网关或个人模式),因此当系统提示你希望安装哪一种版本网关时,请确保选择本地数据网关(个人模式)。You can follow the installation steps, and since the installation process allows you to install either version of the gateway (the standard gateway, which can be shared with others, or personal mode), make sure you select on-premises data gateway (personal mode) when prompted for which version of the gateway you want to install.

从以前版本的个人网关进行更新Updating from the previous personal gateway

如果已安装“Power BI 网关 - 个人版”网关,当在“Power BI 服务”中查看“设置”下的“数据集”时,系统将提示安装新的增强版个人网关。If you already have the Power BI Gateway - personal gateway installed, you'll be prompted to install the new and enhanced version of the personal gateway when you view Datasets under Settings in the Power BI service.

选择数据集并选择“网关连接”后,系统将通知有可用的新增强版个人网关。When you select a dataset, and then select Gateway connection you're notified that the new and enhanced version of the personal gateway is available. 执行此操作后,选择“立即安装”。When you do, select Install now.

备注

如果正在以提升的进程运行以前版本的“Power BI Gateway - personal”,请确保同样以提升的方式启动新网关安装进程,使数据集凭据自动更新。If you're running the previous version of Power BI Gateway - personal as an elevated process, make sure you start the new gateway installation process elevated as well, so your dataset credentials can be automatically updated. 否则将必须手动更新数据集凭据。Otherwise, you'll have to update dataset credentials manually.

将执行更新过程,随后将显示安装已成功。You'll be taken through the update process, after which you'll see that the installation was successful. 此时请勿关闭页面,因为还有最后一步。Don't close things out yet, there's one last step.

下面是最后一步。Here's the last step. 新的个人网关安装后(最后的安装屏幕仍显示),请登录 Power BI 服务,等待显示网关处于联机状态,如下图所示。Once the new personal gateway is installed (and the last installation screen still visible), sign in to the Power BI service, and wait until you see that the gateway is online, as shown in the following image.

如果已在安装以前版本网关的同一台计算机上更新个人网关,凭据将自动更新,所有刷新活动都将在新网关上进行。If you've updated the personal gateway on the same machine as the previous gateway is installed, your credentials will update automatically, and all refresh activities will go through the new gateway. 如果以前版本网关安装在另一台计算机上,系统会提示你更新某些数据集上的凭据。If the previous gateway was installed on a different machine, you'll be asked to update your credentials on certain datasets. 请注意上图窗口中的数据集列表;此列表将显示可能需要更新凭据的数据集。In the previous image, notice the list of datasets in the window; the list will show datasets that might require updated credentials. 列出的每个数据集都是直接链接,只需单击即可轻松更新凭据。Each dataset listed is a direct link that you simply click on to easily update your credentials.

就是这样简单。That's it - almost. 安装新网关后,计算机上不再需要已安装的以前版本网关,因此应将其卸载。With the new gateway installed, you no longer need to previous version installed on your machine, so you should uninstall it. 为此,可在计算机上搜索“Power BI 网关 - 个人版”并将其卸载。You can do this by searching for Power BI Gateway - personal on your machine, and uninstalling it.

确定已安装的个人网关版本Determining which version of the personal gateway you have installed

若要确定当前已安装的个人网关版本,可执行以下操作:To determine which version of the personal gateway you currently have installed, you can do the following:

  • 以前版本个人网关名为“Power BI 网关 - 个人版”并且在其安装对话框中使用 Power BI 图标。The previous version of the personal gateway is called Power BI Gateway - Personal and uses the Power BI icon in its installation dialog.
  • 新版个人网关名为“本地数据网关(个人模式)”并且使用网关图标(云形,底部有上下箭头)。The new version of the personal gateway is called on-premises data gateway (personal mode) and uses the gateway icon (a cloud with an up-and-down arrow along the bottom).

可以转到“添加/删除程序”,查看“Power BI 网关 - 个人版”是否出现在列表中,如果是,则说明安装的是以前版本个人网关。You can go to Add/Remove Programs and see whether Power BI Gateway - Personal appears on the list, and if so, you have the previous version of the personal gateway installed.

将快速合并用于个人网关Using Fast Combine with the personal gateway

如果之前对以前版本网关使用了快速合并,则需要执行以下步骤重新启用快速合并,使其适用于本地数据网关(个人模式):If you were using Fast Combine with the previous gateway, you'll need to take the following steps to re-enable Fast Combine to work with the on-premises data gateway (personal mode):

  1. 使用文件资源管理器,打开以下文件:Using File Explorer, open the following file:

    %localappdata%\Microsoft\on-premises data gateway (personal mode)\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config
    
  2. 在文件底部添加下列文本:At the bottom of the file, add the following text:

    ```
    <setting name="EnableFastCombine" serializeAs="String">```
    <value>true</value>
    </setting>
    ```
    
  3. 完成后,该设置将在大约一分钟后生效。Once complete, the setting will take effect in approximately one minute. 若要检查设置是否有效,请尝试在 Power BI 服务中执行按需刷新,确认快速合并是否正常工作。To check that it's working properly, try an on-demand refresh in the Power BI service to confirm that Fast Combine is working.

限制和注意事项Limitations and considerations

使用本地数据网关(个人模式)有几点注意事项,如以下列表所述。There are a few things to consider when using the on-premises data gateway (personal mode), as described in the following list.

  • 如果使用 Windows Hello 或 PIN 登录 Windows,可能遇到以下错误:If you're using Windows Hello or a pin to sign in to Windows, you might run into the following error:
    • 你选择的用户帐户不符合应用程序的要求。请使用其他帐户。The user account you selected does not match the requirements of the application. Please use a different account.*
    • 若要更正该错误,请选择“使用其他帐户”并再次登录。To remedy that error, select Use a different account and sign in again.

本地数据网关(个人模式)目前不支持下列数据源:The following data sources are currently not supported for the on-premises data gateway (personal mode):

  • ADO.NETADO.NET
  • CurrentWorkbookCurrentWorkbook
  • FTPFTP
  • HDFSHDFS
  • SAP BusinessObjectsSAP BusinessObjects
  • SparkSpark

已规划 2017 日历年下半年对 Spark 的支持。Support for Spark is planned for the second half of the 2017 calendar year.

常见问题解答 (FAQ)Frequently Asked Questions (FAQ)

  • 是否可以同时运行本地数据网关(个人模式)和本地数据网关(以前称为“企业版网关”)?Can I run the on-premises data gateway (personal mode) side by side with the on-premises data gateway (previously known as the Enterprise version of the gateway)?

    • 回答:可以,使用新版本时二者可以同时运行。Answer: Yes, with the new version, both can run simultaneously.
  • 是否可以将本地数据网关(个人模式)作为服务运行?Can I run the on-premises data gateway (personal mode) as a service?

    • 回答:不能。Answer: No. 本地数据网关(个人模式)只能作为应用程序运行。the on-premises data gateway (personal mode) can only run as an application. 如果需要将网关作为服务并/或在管理模式下运行,请考虑使用本地数据网关(以前称为“企业网关”)。If you need to run the gateway as a service and/or in admin mode, you'll need to consider the on-premises data gateway (previously known as the Enterprise gateway).
  • 本地数据网关(个人模式)多久更新一次?How often is the on-premises data gateway (personal mode) updated?

    • 回答:我们计划每月更新一次个人网关。Answer: We plan to update the personal gateway monthly.
  • 为什么要求我更新凭据?Why am I asked to update my credentials?

    • 回答:很多情况都会触发对凭据的请求。Answer: Many situations can trigger a request for credentials. 安装本地数据网关(个人模式)的计算机与已安装“Power BI - 个人版”网关的计算机不同是最常见的情况。The most common is that you've re-installed the on-premises data gateway (personal mode) on a different machine than your Power BI - personal gateway. 还可能是数据源问题、Power BI 未能执行测试连接,或是出现超时或系统错误。It could also be an issue in the data source, and Power BI failed to perform a test connection, or a timeout or a system error occurred. 可以在 Power BI 服务中更新凭据,方法是转到齿轮图标,依次选择“设置”、“数据集”,找到有问题的数据集,然后单击“更新凭据”。You can update your credentials in the Power BI service by going to the gear icon and selecting Settings then Datasets, and finding the dataset in question and clicking on update credentials.
  • 升级期间,以前版本个人网关会有多长时间处于脱机状态?How much time will my previous personal gateway be offline during the upgrade?

    • 回答:将个人网关升级到新版本应该仅需几分钟。Answer: Upgrading the personal gateway to the new version should only take few minutes.
  • 如果 2017 年 7 月 31 日前未迁移到新版个人网关,会出现什么状况?What happens if I don't migrate to the new personal gateway by July 31st, 2017?

    • 回答:如果使用当前网关刷新报表,则刷新将停止。Answer: If you’re refreshing your reports with the current gateway, your refreshes will stop. 设置新刷新计划的唯一方式是安装并配置新网关。The only way to set up a new refresh schedule will be by installing and configuring the new gateway.
  • 我使用的是 R 脚本。I'm using R script. 它受支持吗?Is that supported?

    • 回答: 我们预计会很快添加对 R 脚本的支持。Answer: We anticipating adding support for R scripts soon.
  • 为什么在 Power BI 服务中看不到更新网关的消息?Why am I not seeing the message to update my gateway in the Power BI service?

    • 回答:很可能是因为你的一个或多个数据集中包含一个目前不受支持的数据源。Answer: Most likely, this is because you have one or more datasets that include a data source that is still currently not supported.

后续步骤Next steps

为 Power BI Gateway 配置代理设置Configuring proxy settings for the Power BI Gateways
更多问题?More questions? 尝试参与 Power BI 社区Try the Power BI Community