Friday, October 28, 2016

Build modern BI solutions using SSRS 2016 – Slides and Useful Links

As promised, here are the responses for the questions I remembered and I will watch the recorded video and post some responses over the next week just in case if I missed any.

PowerPoint Slides: https://1drv.ms/b/s!AqQY0KY6_6uRmQiXQ6wP1Xrq4hEm

Custom Brand Package using SSRS 2016

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/03/20/how-to-create-a-custom-brand-package-for-reporting-services-with-sql-server-2016/
https://msdn.microsoft.com/en-us/library/mt710551.aspx


SSRS 2016 Native mode vs SharePoint Integrated mode


Feature
Integrated Mode
Native Mode
HTML 5 based rendering Engine
X
X
New Chart Types
X
X
PDF based printing (No ActiveX)
X
X
PowerPoint rendering and Export
X
X
New UI for Report Builder
X
X
Customisable Parameter Panes
X
New Web Portal
X
Mobile Reports
X
KPIs
X
Pin to Power BI
X
Render Power BI Reports in SSRS Portal
X (preview released)

SSRS 2016 and Windows Authentication and Mobile Reports
https://msdn.microsoft.com/en-us/library/cc281253.aspx

Whether Mobile Reports are available for Standard Edition? – No, it is available only for Enterprise Edition currently. Check Data Sheet for SQL Server 2016

Checklist to decide on Paginated Reports vs Mobile Reports – Coming soon

Pin Reporting Services item with Power BI
https://msdn.microsoft.com/en-us/library/mt604784.aspx

Check blog post - http://codespot.blogspot.co.nz/2016/10/pin-ssrs-2016-reports-to-power-bi.html

Note: You can pin only certain report elements only to the Power BI Portal. e.g. tables cannot be pinned for now. Sorry, I wasn't able to validate that perfectly until now as I had to fix an issue with linking Power BI and SSRS 2016.

Is it possible to access the Reports both through Report Server and Reports URL?
Yes, it is still available for Paginated Reports but not yet for Mobile Reports and KPIs.https://msdn.microsoft.com/en-us/library/ms153586.aspx
ReportServerURL1

Below is the error you get for Mobile Reports and KPIs if you try to access it through the Report Server URL.
ReportServerURL2

Mobile Reports Samples

Thanks Christopher Finlan

Report Authoring Tools - https://msdn.microsoft.com/en-us/library/ms155792.aspx

Mobile Reports and Version Control – Coming soon

List of Data Sources supported by SSRS and mobile reports - https://msdn.microsoft.com/library/ms159219.aspx
https://msdn.microsoft.com/en-nz/library/mt631348.aspx

No comments:

Post a Comment