SQL Server 2016 Reporting Services Go Mobile, Power BI Tells Stories
The software maker outlines SQL Server's new mobile reporting capabilities and debuts new "narrative" Power BI reports.New R-friendly capabilities aside, the latest SQL Server 2016 release candidate (RC3) features supports for the company's new Mobile Report Publisher software. Now, Microsoft is giving perspective customers a look at how they can use the company's database software to deliver business insights to their users' smartphones and tablets. When used in conjunction with SQL Server's Reporting Services (SSRS), the preview version of Microsoft's Mobile Report Publisher tool enables companies to create, publish and manage mobile-friendly reports for their employees. For example, a retailer can use SSRS and the Mobile Report Publisher feature to issue an overview of daily sales to its managers. The reports can be viewed using a Power BI mobile app or with a Web browser. In SQL Server 2016 RC3, Mobile Report Publisher now supports the ability to save a report to multiple servers. After saving a report locally, users can use the SSRS upload capability to publish reports to other servers. Microsoft cautions that the pertinent data sources and datasets must adhere to the same folder path on each server for the reports to display properly. Microsoft also removed some log-in hurdles for organizations that use the company's user access management technologies. "In addition to both NTLM [NT LAN Manager] and Basic Authentication, we've added support for companies that use the Negotiate authentication option on their server and streamlined the sign-in process," Christopher Finlan, a senior program manager at Microsoft SQL Server Reporting Services, said in a blog post.
"Now, when you connect to a new report server, it will try to connect you automatically based on your current Windows credentials," he continued. The manual option remains for organizations that prefer it.