Power BI 报表服务器中的新增功能What's new in Power BI Report Server

了解 Power BI 报表服务器中的新增功能。Learn about what's new in Power BI Report Server. 本文涉及主要功能方面,并会在新功能发布时随之进行更新。This covers the major feature areas and is updated as new items are released.

若要下载 Power BI 报表服务器和针对 Power BI 报表服务器进行了优化的 Power BI Desktop,请转到使用 Power BI 报表服务器进行本地报告To download Power BI Report Server, and Power BI Desktop optimized for Power BI Report Server, go to On-premises reporting with Power BI Report Server.

提示 有关最新发行说明,请参阅 Power BI 报表服务器 - 发行说明tip For the current release notes, see Power BI Report Server - Release notes.

有关相关的“新增功能”的信息,请参阅:For related "What's New" information, see:

2017 年 10 月版本October 2017 release

Power BI 报表数据源Power BI report data sources

Power BI 报表服务器中的 Power BI 报表可以连接到各种数据源。Power BI reports in Power BI Report Server can connect to a variety of data sources. 可以导入数据和计划数据刷新,或者直接使用 DirectQuery 或与 SQL Server Analysis Services 的实时连接查询数据。You can import data and schedule data refresh, or query it directly using DirectQuery or a live connection to SQL Server Analysis Services. 请参阅支持计划的刷新和支持“Power BI 报表服务器中的 Power BI 报表数据源”中的 DirectQuery 的数据源列表。See the list of data sources that support scheduled refresh and those that support DirectQuery in "Power BI report data sources in Power BI Report Server".

导入的数据的计划数据刷新Scheduled data refresh for imported data

在 Power BI 报表服务器中,可以设置计划的数据刷新,以使用嵌入式模型(而不是实时连接或 DirectQuery)使 Power BI 报表中的数据始终保持最新。In Power BI Report Server, you can set up scheduled data refresh to keep data up to date in Power BI reports with an embedded model rather than a live connection or DirectQuery. 由于使用嵌入式模型导入数据,一次它会与原始数据源断开连接。With an embedded model you import the data, so it's disconnected from the original data source. 它需要更新以便数据保持最新状态,而计划的刷新就可以实现这一点。It needs to be updated to keep the data fresh, and scheduled refresh is the way to do that. 详细了解“Power BI 报表服务器中 Power BI 报表的计划刷新”。Read more about "scheduled refresh for Power BI reports in Power BI Report Server".

从服务器编辑 Power BI 报表Editing Power BI reports from the server

可以从服务器打开和编辑 Power BI 报表 (.pbix) 文件,而且可以找回上传的原始文件。You can open and edit Power BI report (.pbix) files from the server, but you get back the original file you uploaded. 这意味着,如果数据已由服务器刷新,则在首次打开该文件时将不会刷新数据。This means if the data has been refreshed by the server, the data won’t be refreshed when you first open the file. 需要在本地手动刷新才能查看更改。You need to manually refresh it locally to see the change.

大型文件上传/下载Large file upload/download

可以上传最大 2 GB 的文件(在 SQL Server Management Studio (SSMS) 的报表服务器设置中,此限制默认设置为 1 GB)。You can upload files up to 2 GB in size, though by default this limit is set to 1 GB in the Report Server settings in SQL Server Management Studio (SSMS). 这些文件存储在数据库中,就像它们适用于 SharePoint 一样,并且不需要对 SQL Server 目录进行任何特殊配置。These files are stored in the database just as they are for SharePoint, and no special configuration for the SQL Server catalog is required.

通过 OData 源访问共享数据集Accessing shared datasets as OData feeds

可以使用 OData 源从 Power BI Desktop 访问共享数据集。You can access shared datasets from Power BI Desktop with an OData feed. 有关详细信息,请参阅在 Power BI 报表服务器中通过 OData 源访问共享数据集For more information, see Accessing shared datasets as OData feeds in Power BI Report Server.

横向扩展Scale-out

此版本支持横向扩展。使用负载均衡器并设置服务器关联以获得最佳体验。This release supports scale-out. Use a load-balancer and set server affinity for the best experience. 请注意,该方案尚未针对横向扩展进行优化,因此,将看到模型可能会在多个节点之间复制。Note that the scenario is not yet optimized for scale-out, so you'll see models potentially replicated across multiple nodes. 该方案将在没有网络负载均衡器和粘性会话的情况下运行。The scenario will work without the Network Load Balancer and sticky sessions. 但是,加载模型 N 次时,不仅会看到跨节点的内存过度使用,而且连接之间的性能会下降,因为在模型抵达两个请求之间的新节点时会对其进行流式传输。However, you'll not only see an over-use of memory across nodes as the model is loaded N times, but performance will slow in between connections as the model is streamed as it hits a new node in between requests.

管理员设置Administrator settings

管理员可以在服务器场的 SSMS 高级属性中设置以下属性:Administrators can set the following properties in SSMS Advanced Properties for the server farm:

  • EnableCustomVisuals:True/FalseEnableCustomVisuals: True/False
  • EnablePowerBIReportEmbeddedModels:True/FalseEnablePowerBIReportEmbeddedModels: True/False
  • EnablePowerBIReportExportData:True/FalseEnablePowerBIReportExportData: True/False
  • MaxFileSizeMb:默认值现在为 1000MaxFileSizeMb: Default is now 1000
  • ModelCleanupCycleMinutes:检查并从内存中收回模型的频率ModelCleanupCycleMinutes: How often it checks to evict models from memory
  • ModelExpirationMinutes:根据上次使用时间,定义模型过期并被收回的时长ModelExpirationMinutes: How long until model expires and is evicted, based on last time used
  • ScheduleRefreshTimeoutMinutes:一个模型的数据刷新可能需要的时长。ScheduleRefreshTimeoutMinutes: How long data refresh can take for a model. 默认情况下,此值为两个小时。By default, this is two hours. 没有固定上限。There is no hard upper limit.

配置文件 rsreportserver.configConfig file rsreportserver.config

<Configuration>
  <Service>
    <PollingInterval>10</PollingInterval>
    <IsDataModelRefreshService>false</IsDataModelRefreshService>
    <MaxQueueThreads>0</MaxQueueThreads>
  </Service>
</Configuration>

开发人员 APIDeveloper API

为 SSRS 2017 引入的开发人员 API (REST API) 已针对 Power BI 报表服务器进行了扩展,以便处理 Excel 文件和 .pbix 文件。The developer API (REST API) introduced for SSRS 2017 has been extended for Power BI Report Server to work with both Excel files and .pbix files. 一个可能的用例是以编程方式从服务器下载文件,对文件进行刷新,然后重新发布文件。One potential use case is to programmatically download files from the server, refresh them, and then republish them. 例如,这是使用 PowerPivot 模型刷新 Excel 工作簿的唯一方法。This is the only way to refresh Excel workbooks with PowerPivot models, for example.

请注意,有一个单独的新 API 适用于将在 Swagger 的 Power BI 报表服务器版本中进行更新的大型文件。Note that there is a new separate API for large files, which will be updated in the Power BI Report Server version of Swagger.

SQL Server Analysis Services (SSAS) 和 Power BI 报表服务器的内存占用情况SQL Server Analysis Services (SSAS) and the Power BI Report Server memory footprint

Power BI 报表服务器现在可在内部托管 SQL Server Analysis Services (SSAS)。Power BI Report Server now hosts SQL Server Analysis Services (SSAS) internally. 这并非特定于计划的刷新。This isn't specific to scheduled refresh. 托管 SSAS 可以极大地扩展报表服务器的内存占用情况。Hosting SSAS can greatly expand the report server memory footprint. AS.ini 配置文件在服务器节点上可用,因此,如果用户熟悉 SSAS,可能想要更新设置,其中包括最大内存限制和磁盘缓存等。有关详细信息,请参阅 Analysis Services 中的服务器属性The AS.ini configuration file is available on the server nodes, so if you're familiar with SSAS, you may want to update the settings, including maximum memory limit and disk caching etc. See Server properties in Analysis Services for details.

查看 Excel 工作簿并与之交互Viewing and interacting with Excel workbooks

Excel 和 Power BI 包含行业中独一无二的一套工具。Excel and Power BI contain a portfolio of tools that is unique in the industry. 同时,它们使业务分析师更轻松地收集数据、构建数据模型、分析并以可视化方式浏览数据。Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. 除了在 Web 门户中查看 Power BI 报表之外,企业用户现在也可以使用 Power BI 报表服务器中的 Excel 工作簿执行相同的操作,从而向用户提供单个位置来发布和查看其自助服务 Microsoft BI 内容。In addition to viewing Power BI reports in the web portal, business users can now do the same with Excel workbooks in Power BI Report Server, giving them a single location to publish and view their self-service Microsoft BI content.

我们已发布了如何将 Office Online Server (OOS) 添加到 Power BI 报表服务器预览环境的演练We’ve published a walkthrough of how to add Office Online Server (OOS) to your Power BI Report Server preview environment. 具有批量许可帐户的客户可以从批量许可服务中心免费下载 OOS,并且将具有仅查看功能。Customers with a Volume Licensing account can download OOS from the Volume License Servicing Center at no cost and will have view-only functionality. 配置后,用户可以查看具有以下特点的 Excel 工作簿并与之交互:Once configured, users can view and interact with Excel workbooks that:

  • 没有外部数据源依赖关系Have no external data source dependencies
  • 实时连接到外部 SQL Server Analysis Services 数据源Have a live connection to an external SQL Server Analysis Services data source
  • 具有 PowerPivot 数据模型Have a PowerPivot data model

支持新的表和矩阵视觉对象Support for new table and matrix visuals

Power BI 报表服务器现在支持新的 Power BI 表和矩阵视觉对象。Power BI Report Server now supports the new Power BI table and matrix visuals. 若要创建具有这些视觉对象的报表,需要 2017 年 10 月发布的更新的 Power BI Desktop 版本。To create reports with these visuals, you will need an updated Power BI Desktop release for the October 2017 release. 它不能与 Power BI Desktop(2017 年 6 月)版本并行安装。It can't be installed side-by-side with the Power BI Desktop (June 2017) release. 对于最新版本的 Power BI Desktop,请在 Power BI 报表服务器下载页上选择“高级下载选项”。For the latest version of Power BI Desktop, on the Power BI Report Server download page, select Advanced download options.

2017 年 6 月June 2017

  • Power BI 报表服务器已正式发布 (GA)。Power BI Report Server made generally available (GA).

2017 年 5 月May 2017

  • Power BI 报表服务器预览版已发布Power BI Report Server Preview made available
  • 可以在本地发布 Power BI 报表Ability to publish Power BI reports on-premises
    • 支持自定义视觉对象Suppport for custom visuals
    • 仅支持 Analysis Services 实时连接,今后将会支持更多数据源。Support for Analysis Services live connections only with more data sources to come.
    • Power BI 移动应用更新为显示在 Power BI 报表服务器中托管的 Power BI 报表Power BI Mobile app updated to display Power BI reports hosted in Power BI Report Server
  • 通过注释增强了报表协作Enhanced collaboration in reports with comments

后续步骤Next steps

Power BI 报表服务器发行说明Power BI Report Server release notes
用户手册User handbook
管理员手册Administrator handbook
快速入门:安装 Power BI 报表服务器Quickstart: Install Power BI Report Server
安装报表生成器Install Report Builder
下载 SQL Server Data Tools (SSDT)Download SQL Server Data Tools (SSDT)

更多问题?More questions? 尝试咨询 Power BI 社区Try asking the Power BI Community