Planning and Deploying PBIRS on premise Bob Duffy

Planning and Deploying PBIRS on premise! Bob Duffy, MCA, MCM, MVP, SSAS Maestro #Data. BISummit

Bob Duffy • 22 years in database sector, 250+ projects • SQL Server MCA, MCM, MVP • SSAS Maestro • Senior Data Platform Consultant with Microsoft 2005 -2008 • Database Architect at Prodata SQL Centre of Excellence • http: //blogs. prodata. ie/author/bob. aspx • bob@prodata. ie #Data. BISummit

Agenda • Architecture • Scalability • Hardware and Capacity Planning • Authentication and Kerberos • Service Accounts • Office Integration • Licensing #Data. BISummit

The Official Features for PBI Report https: //docs. microsoft. com/en-us/power-bi/whitepapers #Data. BISummit

Five Main Benefits – IN A SINGLE Portal Feature Benefit Power BI Reports Self Service Interactive Analytics Integration Mobile friendly Data Mashup Sexy ; -) Mobile Reports First Class KPIs Best of breed mobile dashboards Offline data caching Office Online Integrated Excel in the Web App SSAS Pivot tables Excel report and dashboards Ah Hoc Analysis Paginated Reports Latest classic SSRS Engine Pixel perfect printing Static Reporting Email distribution Embedded Analysis Services Host Power. BI Models in local SSAS 1 -2 GB max size #Data. BISummit

What’s Installed on the Server? Demo #Data. BISummit

Technical Architecture and Scalability Key Technical Architecture Questions 1. Support for extranet users v DMZ ? 2. Scale up or out ? 3. Load Balance or not ? 4. Full SSAS Tabular or hosted SSAS for PBIX #Data. BISummit

Capacity Planning https: //docs. microsoft. com/en-us/power-bi/report-server/capacity-planning #Data. BISummit

Selecting the Right Hardware • Sensitive to CPU Speed and Ram Performance • Recommendations: • Intel E 5 -26** Series ok • Intel Skylake+ better (Platinum Series) • Consider locking Turbo mode if you want best performance (and don’t pay the power bill) • Use the fastest ram (2, 400 Ghz+) • Virtualization can bump up license price ! • Don’t use NUMA on large tabular models #Data. BISummit

Authentication and Kerberos • Authentication is mainly windows, although Custom is “possible” • Three types of windows authentication with PBIRS • Cached Credentials • Constrained delegation using Kerberos • Cached Credentials with Impersonation • Power. BI online uses Impersonation • SSRS paginated has same options • Office online uses delegation through C 2 W service (Like sharepoint) https: //docs. microsoft. com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports #Data. BISummit

Service Accounts for PBIRS Type Example Pros / Cons Virtual Service Account NT ServiceReport. Server Default Automatic SPN Configuration Domain Account DOMAINsvc. SSRS Centralised Management Manual SPN Configuration Preferred by some security teams Can be shared between services Recommendation: - Use Virtual Service Accounts in simple environments - Use Domain service account in more complex environments (multiple names, co-habiting with IIS) https: //docs. microsoft. com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports #Data. BISummit

Configuring Kerberos Demo #Data. BISummit

Office Online Deployment • Manual Download and Powershell Install • Register in Power. BI SSRS Site Settings https: //docs. microsoft. com/en-us/power-bi/report-server/excel-oos #Data. BISummit

Office Online with Kerberos #Data. BISummit

Licensing PBIRS – Example 1, 000 users • SQL Server EE with Software Assurance • Bought in 2 core packs, about 10 k euro a core • All manner of discounts and payment deals • Be careful with virtualisation and hyper-threading! • About 80 k over 3 years • Power BI Premium • Dedicated cloud cores with ”free” on premise cores • Pricing depends on “Pro Users” • Example for a P 1 8 cores is about 150 k over 3 years #Data. BISummit