PowerBIReportServer_duryan_20170919.pptx

kj

1. Power BI Report Server Self-Service BI and Enterprise Reporting On-Premises Dustin Ryan Data Platform Solution Architect, Microsoft

2. Agenda Overview How to acquire Power BI Report Server for the BI user Power BI Report Server for the IT Pro Scenarios Summary

3. Who is this guy? Data Platform Architect, Microsoft Designing BI solutions 9+ years Previously BI Consultant for partner Microsoft DPSA, TSP for past 2 years Support EDU customers in East Author, blogger, speaker @SQLDusty youtube.com/c/DustinRyan SQLDusty.com Linkedin.com/in/sqldusty

4. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

5. Power BI Custom Visualizations Live Dashboards Natural Language Query Power BI: experience your data Any data, any way, anywhere Mobile PC HoloLens DATA ACTIONS INSIGHTS Cloud On-premises Automation Apps People Get started quickly Power BI: experience your data Any data, any way, anywhere Power BI reports

6. Power BI: extending on-premises capabilities Power BI: extending on-premises capabilities Custom Visualizations Live Dashboards Natural Language Query Get started quickly Power BI reports Power BI SSRS reports Power BI reports Custom Visualizations Power BI Report Server

7. Move to the cloud on your terms Compatible with SSRS Power BI Report Server Self-service BI and enterprise reporting in one solution Keep Power BI reports on-premises SSRS reports Power BI reports Custom Visualizations Power BI Report Server

8. Interactive Power BI Reports TAG Keep Power BI reports on-premises Interactive reports to visualize your data and gain insights Variety of built-in and custom visuals Filter at a visual, page, or report level Drill to details

9. Consume in multiple ways Web browser, mobile app, or embedded into your app Benefit from an enterprise-ready solution Organize reports, manage permissions, audit usage Publish SSRS reports Create precisely-formatted paginated reports Power BI Report Server Self service BI and enterprise reporting in one solution Compatible with SSRS Built on proven SQL Server Reporting Services technology

10. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

11. How to acquire Power BI Report Server SQL Server Enterprise + Software Assurance Power BI Premium Power BI Pro license required to publish Power BI reports to Power BI Report Server

12. Power BI Premium Dedicated r esources in the cloud Greater scale and performance Flexibility to license by capacity Extending on-premises capabilities Embedded analytics Power BI Premium

13. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

14. Power BI Report Server Create interactive reports in Power BI Desktop Create Publish Publish to Power BI Report Server Consume View and interact in Power BI Mobile or web browser

15. Create beautiful, interactive reports Using Power BI Desktop Connect to Analysis Services (Tabular or Multidimensional) Variety of built-in and custom visuals Additional data sources currently in preview

16. Create modern paginated reports Design beautiful documents quickly and easily Optimized for document generation and printing Page headers, footers, and page breaks Precise layout and formatting Conditional formatting and visibility Modern chart and gauge styles

17. View and interact with Excel workbooks Publish paginated, Power BI, and Excel reports in a single location Use a PowerPivot data model Use live connection to Analysis Services (Tabular)

18. Publish and manage reports Power BI Desktop Publish to Power BI Report Server Re-open, edit, and save back Organize and manage access to reports Power BI Report Server

19. HTML5 rs:Embed =true Consume reports in multiple ways Mobile apps </> Windows Android iOS Web portal Embedded In your apps

20. Demo

21. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

22. Power BI Report Server for the IT Pro Lifecycle Frequent releases Security Integrate with ADFS Scale up and out Scalability Migrate from SQL Server Reporting Services Migration Installation Lightweight download and installation

23. Install in minutes Lightweight download and installation Requirements Windows Server 2012+ SQL Server Database Engine (2008+) SQL Server Analysis Services (2012+) Zero impact on SQL Server

24. Migrate from SSRS (Native mode) SSRS Power BI Report Server Back up report server database Install Power BI Report Server Connect report server to database using Report Server Configuration Manager Copy/Move Report Server Database Report Server Database

25. Migrate from SSRS (SharePoint-integrated mode) Sample Script rs.exe - i ssrs_migration.rss -e Mgmt2010 -s http://SourceServer/_vti_bin/reportserver -v st ="sites/bi" -v f="Shared Documents“ -u Domain\User1 -p Password -v ts = http://TargetServer/reportserver -v tu ="Domain\User" -v tp ="Password" SharePoint Migrate Reports Power BI Report Server SSRS

26. Scale-out report servers Report Server Report Server Report Server Database Load Balancer Users

27. Integrate with ADFS Client Devices Internet Firewall Firewall AD FS AD DS Corporate Network Web Application Proxy Power BI Report Server

28. Modern Lifecycle Policy Year 1 Year 2 Security & Critical Updates Security Updates (Only) Security & Critical Updates Security Updates (Only ) Security & Critical Updates Security Updates (Only ) Release 1 Release 2 Release 3 Support Ends New Release Frequent releases (planning ~3 per year) Security & critical updates until next release Security updates continue for remainder of 12 months

29. Updating Power BI Desktop + Report Server IT Pro Power BI Report Server Power BI Desktop Upgrade Need to coordinate deployment of updates Power BI Report Server and Power BI Desktop release concurrently Upgrade

30. Demo

31. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

32. Scenarios for all reporting products My organization wants an on-premises solution to generate precisely-formatted operational reports My organization wants an on-premises solution for self-service BI as well as operational reporting My organization wants a managed Software-as-a-Service (SaaS) solution for next-generation, business user-led BI , complete with Apps, real-time Dashboards, Q&A, and more SQL Server Reporting Services Power BI Report Server Power BI service

33. Compare reporting options SQL Server Reporting Services Power BI Report Server Power BI Service Deployment On-premises On-premises Cloud Power BI dashboards  Power BI apps  Natural language query (Q&A)  Power BI reports   Paginated reports (RDL)   Mobile reports ( Datazen -based)   How to buy SQL Server [1] Power BI/SQL Server [2] Power BI Feature updates SQL Server release cycle Rapid release cycle Rapid release cycle Support lifecycle SQL Server support policy Modern Lifecycle Policy Managed service SQL Server Standard or Enterprise. Power BI Premium (or SQL Server Enterprise with Software Assurance) per core + Power BI Pro per report publisher

34. Report Server for the BI user Report Server for the IT Pro How to acquire Scenarios Summary Overview

35. Call to action Download Power BI Report Server Or download August 2017 Power BI Report Server Preview Read the documentation Subscribe to the Power BI Blog Follow @ MSPowerBI on Twitter Join the Power BI Community