What's new in Power BI Report Server
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:
- What's new in the Power BI service
- What's new in Power BI Desktop
- What's new in the mobile apps for Power BI
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
- Report Theming
- Buttons to trigger actions
- Combo chart line styles
- Improved default sort for visuals
- Numeric slicer
- Advanced slicer syncing
- Log axis improvements
- Data label options for funnel chart
- Set line stroke width to zero
- High contrast support for reports
- Donut radius control
- Pie and donut detail labels position control
- Format data labels separately for each measure in a combo chart
- New visual header with more flexibility and formatting
- Wallpaper formatting
- Tooltips for table & matrix
- Turn tooltips off for visuals
- Slicer accessibility
- Formatting pane improvements
- Stepped line support for line and combo charts
- Sorting experience improvement
- Print reports through Export to PDF (in Power BI Desktop)
- Create bookmark groups
- Slicer restatement
- Report page tooltips
Analytics
- New DAX function: COMBINEVALUES()
- Measure drillthrough
- Conditional formatting by a different field
- Conditional formatting by values
Modeling
- Filtering and sorting in data view
- Improved locale formatting
- Data categories for measures
- Statistical DAX functions
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.
- Cross-highlighting for bookmarks: Bookmarks maintain and display the cross-highlighted state of the report page at the time you created the bookmark.
- More bookmark flexibility: Bookmarks reflect the properties you set in your report, and affect only the visuals you choose.
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
- Cell alignment for table and matrix
- Display units and precision control for table & matrix columns
- Overflow data labels for bar and column charts
- Control data label background color for Cartesian and maps visuals
- Bar/column padding control
- Increase area used for axis labels in charts
- Scatter visual from x- & y-axis groupings
- High density sampling for maps based on latitude and longitude
- Responsive slicers
- Add an anchor date for relative date slicer
Reporting
- Turn off the visual header in reading mode for a report
- Report options for slow data sources
- Improved default visual placement
- Control visual ordering through the selection pane
- Lock objects on your report
- Search the formatting and analytics pane
- Field properties pane and field descriptions
Analytics
- UTCNOW() and UTCTODAY()
- Mark custom date table
- Drill filters other visuals
- Cell-level formatting for multidimensional AS models for multi-row card
Performance
- Filtering performance improvements
- DirectQuery performance improvements
- Open and save performance improvements
- “Show items with no data” improvements
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
- Add Column From Examples improvements
- Consulting Services quick link
- Improved error reporting
- View previous errors you’ve encountered
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
Feedback
We'd love to hear your thoughts. Choose the type you'd like to provide:
Our feedback system is built on GitHub Issues. Read more on our blog.
Loading feedback...