What's new in Power BI Report Server

  • 12 minutes to read
  • Contributors
    • Mark Ghanayem
    • Nick Schonning
    • Maggie Sparkman
    • Michael Blythe
    • Adam Saxton

Learn about what's new in Power BI Report Server. This article covers the major feature areas and is updated as new items are released.

To download the latest versions of Power BI Report Server and Power BI Desktop optimized for Power BI Report Server, go to On-premises reporting with Power BI Report Server.

For related Power BI "What's New" information, see:

January 2019

Support for these features in Power BI reports:

Row-level security Setting up row-level security (RLS) with Power BI Report Server can restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.

Expand and collapse on matrix row headers We've added the ability to expand and collapse individual row headers, one of the most requested visual features.

Copy and paste between .pbix files You can copy visuals between .pbix files, either from the visual’s context menu or with the standard Ctrl+C keyboard shortcut, and paste it into another report with Ctrl+V.

Smart alignment guides You see smart alignment guides when moving objects on your report page, like you see in PowerPoint, to help you align everything on your page. You see the smart guides any time you drag or resize something on your page. When you move an object near another one, it snaps into a position aligned with the other object.

Accessibility features Too many accessibility features to list: for example, fields list pane accessibility support. The fields list pane is fully accessible. You can navigate around the pane using just your keyboard and a screen reader and use the context menu to add fields to your report page.

Administrator settings

Administrators can set the following properties in SSMS Advanced Properties for the server farm:

AllowedResourceExtensionsForUpload Set extensions of resources that can be uploaded to the report server. Extensions for built-in file types like *.rdl and *.pbix are not required to be included. Default is “*, *.xml, *.xsd, *.xsl, *.png, *.gif, *.jpg, *.tif, *.jpeg, *.tiff, *.bmp, *.pdf, *.svg, *.rtf, *.txt, *.doc, *.docx, *.pps, *.ppt, *.pptx”.

SupportedHyperlinkSchemes Sets a comma-separated list of the URI schemes allowed to be defined on Hyperlink actions that are allowed to be rendered or “*” to enable all hyperlink schemes. For example, setting “http,https” would allow hyperlinks to “https://www. contoso.com”, but would remove hyperlinks to “mailto:bill@contoso.com” or “javascript:window.open(‘www.contoso.com’, ‘_blank’)”. Default is “*”.

August 2018

August 2018 sees many new features added to the version of Power BI Desktop optimized for Power BI Report Server. Here they are, broken out by area:

Highlights of the August 2018 release

Out of the whole long list of new features, these features stand out as especially interesting. For more information, see our blog post.

Report theming

Report theming has been added to the August 2018 release of Power BI Report Server, which allows you to quickly color your entire report to match a theme or corporate branding. When you import a theme, all your charts automatically update to use the theme colors, and you can have access to the theme colors from the color palette. You can upload a theme file using the Import Theme option under the Switch Theme button.

A theme file is a JSON file that includes all the colors you want us to use in your report along with any default formatting you want to apply to visuals. Here is a simple sample JSON theme that just updates the default colors of the report:

{
"name": "waveform",
"dataColors": [ "#31B6FD", "#4584D3", "#5BD078", "#A5D028", "#F5C040", "#05E0DB", "#3153FD", "#4C45D3", "#5BD0B0", "#54D028", "#D0F540", "#057BE0" ],
"background":"#FFFFFF",
"foreground": "#F2F2F2",
"tableAccent":"#5BD078"
}

Conditional formatting by a different field

The ability to format a column by a different field in your model is one of the significant improvements to conditional formatting.

Conditional formatting by values

Another new conditional formatting type is the Format by field value. The Format by field value lets you use a measure or column that specifies a color, either through a hex code or name, and applies that color to the background or font color.

Report page tooltips

The report page tooltips feature is included in the August 2018 update of Power BI Report Server. This feature lets you design a report page to be used as a custom tooltip for other visuals in your report.

Log axis improvements

We’ve greatly improved log axis in your cartesian charts. You should now be able to select log scale for the numeric axis of any cartesian chart, including combo chart, when you have data that is completely positive or completely negative.

SAP HANA SSO Direct Query

SAP HANA SSO Direct Query support with Kerberos is now available for Power BI Reports.

Note

This scenario is supported only when SAP HANA is treated as a relational data source with reports you’ve created in Power BI desktop. To enable this in Power BI Desktop, in the DirectQuery menu under Options, check the “Treat SAP HANA as a relational source” and click OK.

Custom Visuals

  • The API version shipped with this release is 1.13.0.

  • Now custom visuals can fall back to a previous version compatible with the current version of the server API (if available).

Reporting

Analytics

Modeling

May 2018

Configure Power BI iOS mobile apps for report servers remotely

As an IT admin, you can now use your organization's MDM tool to remotely configure Power BI iOS mobile app access to a report server. See Configure Power BI iOS mobile app access to a report server remotely for details.

March 2018

March 2018 sees many, many new features added to the version of Power BI Desktop optimized for Power BI Report Server. Here they are, broken out by area:

Highlights of the March 2018 release

Out of the whole long list of new features, these features stand out as especially interesting.

Rule-based conditional formatting for table and matrix

Create rules to conditionally color the background or font color of a column based on specific business logic in your table or matrix.

Show and hide pages

You want readers to have access to your report, but some of the pages aren't quite finished. Now you can hide them until they're ready. Or you can hide pages from normal navigation, and readers can get to the page by bookmarks or drillthrough.

Bookmarking

Speaking of bookmarking, create bookmarks to tell a story with the data in your report.

Multi-select data points across multiple charts

Select multiple data points in multiple charts and have the cross-filtering apply to the entire page.

Sync slicers across multiple pages of your report

A slicer can apply to one, two, or more pages in a report.

Quick measures

Create new measures based on existing measures and numerical columns in a table.

Drilling down filters other visuals

When you drill down in a given category in one visual, you can have it filter all the visuals on the page by that same category.

Visuals updates

Reporting

Analytics

Performance

Report server

Export to accessible PDF

When you export a paginated (RDL) report to PDF, you can now get an accessible/tagged PDF file. It's larger in size but easier for screen readers and other assistive technologies to read and navigate. You enable accessible PDF by setting the AccessiblePDF device information setting to True. See PDF Device Information Settings and Changing Device Information Settings.

Other improvements

October 2017

Power BI report data sources

Power BI reports in Power BI Report Server can connect to a variety of data sources. You can import data and schedule data refresh, or query it directly using DirectQuery or a live connection to SQL Server Analysis Services. 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

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. Read more about "scheduled refresh for Power BI reports in Power BI Report Server".

Editing Power BI reports from the server

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

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). These files are stored in the database just as they are for SharePoint, and no special configuration for the SQL Server catalog is required.

Accessing shared datasets as OData feeds

You can access shared datasets from Power BI Desktop with an OData feed. 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. 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

Administrators can set the following properties in SSMS Advanced Properties for the server farm:

  • EnableCustomVisuals: True/False
  • EnablePowerBIReportEmbeddedModels: True/False
  • EnablePowerBIReportExportData: True/False
  • MaxFileSizeMb: Default is now 1000
  • ModelCleanupCycleMinutes: How often it checks to evict models from memory
  • ModelExpirationMinutes: How long until model expires and is evicted, based on last time used
  • ScheduleRefreshTimeoutMinutes: How long data refresh can take for a model. By default, this is two hours. There is no hard upper limit.

Config file rsreportserver.config

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

Developer API

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. This is the only way to refresh Excel workbooks with PowerPivot models, for example.

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) and the Power BI Report Server memory footprint

Power BI Report Server now hosts SQL Server Analysis Services (SSAS) internally. This isn't specific to scheduled refresh. Hosting SSAS can greatly expand the report server memory footprint. 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.

Viewing and interacting with Excel workbooks

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. 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.

We’ve published a walkthrough of how to add Office Online Server (OOS) to your Power BI Report Server preview environment. Customers with a Volume Licensing account can download OOS from the Volume License Servicing Center at no cost and will have view-only functionality. Once configured, users can view and interact with Excel workbooks that:

  • Have no external data source dependencies
  • Have a live connection to an external SQL Server Analysis Services data source
  • Have a PowerPivot data model

Support for new table and matrix visuals

Power BI Report Server now supports the new Power BI table and matrix visuals. To create reports with these visuals, you will need an updated Power BI Desktop release for the October 2017 release. It can't be installed side by side with the Power BI Desktop (June 2017) release. For the latest version of Power BI Desktop, on the Power BI Report Server download page, select Advanced download options.

June 2017

  • Power BI Report Server made generally available (GA).

May 2017

  • Power BI Report Server Preview made available
  • Ability to publish Power BI reports on-premises
    • support for custom visuals
    • Support for Analysis Services live connections only with more data sources to come.
    • Power BI Mobile app updated to display Power BI reports hosted in Power BI Report Server
  • Enhanced collaboration in reports with comments

Next steps

Check these sources to keep up-to-date on new features in Power BI Report Server.

More questions? Try asking the Power BI Community