What's new in Power BI Report Server
Learn about what's new in Power BI Report Server. This covers the major feature areas and is updated as new items are released.
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.
For related "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
- Power BI team blog
March 2018 release
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 this release
Out of the whole long list of new features, these stand out as especially interesting.
Create rules to conditionally color the background or font color of a column based on specific business logic in your table or matrix.
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.
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.
Select multiple data points in multiple charts and have the cross-filtering apply to the entire page.
A slicer can apply to one, two, or more pages in a report.
Create new measures based on existing measures and numerical columns in a table.
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.
- 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
- 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
- UTCNOW() and UTCTODAY()
- Mark custom date table
- Drill filters other visuals
- Cell-level formatting for multidimensional AS models for multi-row card
- Filtering performance improvements
- DirectQuery performance improvements
- Open and save performance improvements
- “Show items with no data” improvements
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.
- Add Column From Examples improvements
- Consulting Services quick link
- Improved error reporting
- View previous errors you’ve encountered
October 2017 release
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.
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.
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>
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.
- Power BI Report Server made generally available (GA).
- Power BI Report Server Preview made available
- Ability to publish Power BI reports on-premises
- Suppport 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
More questions? Try asking the Power BI Community