Manually configuring Power BI integration in Reporting Services

SQL Server 2016 Reporting Services bridges the cloud and on-premise gap by enabling customers that make use of both Power BI and Reporting Services to keep track of key data by pinning visuals from Paginated Reports to their Power BI dashboard. Visuals pinned to Power BI dashboards are updated with fresh data regularly, and users… Read more

Deliver reports via email using an email server outside your network

Today’s post is from Sundeep Meda, an engineer who’s been working on Reporting Services and other BI products here at Microsoft since 2010. As part of SQL Server 2016 we introduced a new feature to support delivering reports via email using an SMTP server outside your network. Previously, the only way you could authenticate to… Read more

SQL Server Migration Assistant for Datazen Preview now available

Today, we’re happy to announce the preview version of the SQL Server Migration Assistant for Datazen is now available from the Download Center. Download SQL Server Migration Assistant for Datazen This application is designed to help organizations migrate their existing Datazen Server content, including dashboards and KPI’s, to a SQL Server 2016 Reporting Services server…. Read more

Export reports to PDF with improved support for international text

Today’s post is from Andre Milbradt, an engineer who’s been working on Reporting Services and other BI products here at Microsoft since 1999. For SQL Server 2016 Reporting Services we made a set of improvements to our PDF Renderer targeted at our international customers. Some of them were long-standing feature requests like copy/paste support for… Read more

Passing user names to Analysis Services with personalized connection strings in SQL Server 2016 Reporting Services

Today’s post is from Kay Unkroth, a program manager who’s been working on Reporting Services and Analysis Services here at Microsoft since 2010. A common challenge in Microsoft SharePoint environments configured for claims-based authentication at the front-end concerns the delegation of user identities to backend data services requiring Windows authentication, such as Microsoft SQL Server… Read more

Setting a maximum file size in SQL Server 2016 Reporting Services

Today’s post is from Rhys Schmidtke, an engineer who’s been working on Reporting Services and other BI products here at Microsoft since 2011.  We’ll be doing more of these posts from engineers on the team so they can share with you some of the newest functionality, tips and tricks they’ve learned, or even answer questions from the… Read more

New Mobile Report Publisher preview now available

We’re excited to announce that the latest preview of the Mobile Report Publisher was released last week and is now available for SQL Server 2016.  This latest release should be used in conjunction with SQL Server 2016 Reporting Services RC3, released earlier this month. Download SQL Server 2016 Download Mobile Report Publisher Download Visual C++ Redistributable… Read more

What’s new for KPIs and mobile reports in SQL Server 2016 RC1

Well, we’re moving quickly with our SQL release candidates, and here we are now with RC1 and all its goodness.  In fact, this release offers the biggest enhancements yet to both the Mobile Reports and KPI’s functionality in Reporting Services since we introduced them both last December. To get started, make sure you have the… Read more

How to create a custom brand package for Reporting Services with SQL Server 2016

UPDATE: Thanks for the feedback in the comments section – we’ve updated this post to include brand packages with the default color scheme (one with the Microsoft logo, and one without). – Download the default brand package (without MSFT logo) – Download the default brand package (with MSFT logo) Happy Monday everyone!  I know folks… Read more

SQL Server 2016 RC1: What’s new in Reporting Services

UPDATE: SQL Server 2016 is now available. Just a couple of weeks since we released SQL Server 2016 RC0, we have another preview release with several updates for you to try. SQL Server 2016 RC1 contains a bunch of enhancements to Reporting Services, culminating in the first relatively “feature-complete” preview release of SQL Server 2016 Reporting Services…. Read more