Power BI Report Server guyinacube Adam Saxton Patrick

Power BI Report Server /guyinacube

Adam Saxton Patrick Le. Blanc /guyinacube @patrickdba /guyinacube

Agenda • What is Power BI Report Server? • Configuration Options • Configure Kerberos • High Availability/Disaster Recovery and Scale • Configuring Office Online Server • Embedding • Rest API

What is the Power BI Report Server?

Power BI: experience your data Any data, any way, anywhere

Power BI Report Server

How to acquire Power BI Report Server

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

Create modern paginated reports Design beautiful documents quickly and easily

Installation Migration Scalability Security Lifecycle Lightweight download and installation Migrate from SQL Server Reporting Services Scale up and out Integrate with ADFS Frequent releases

Lightweight download and installation Zero impact on SQL Server Requirements • Windows Server 2012+ • SQL Server Database Engine (2008+)

1. Back up report server database SSRS Power BI Report Server 2. Install Power BI Report Server Copy/Move 3. Connect report server to database using Report Server Configuration Manager Report Server Database

Migrate Reports SSRS Power BI Report Server Share. Point Sample Script rs. exe -i ssrs_migration. rss -e Mgmt 2010 -s http: //Source. Server/_vti_bin/reportserver -v st="sites/bi" -v f="Shared Documents“ -u DomainUser 1 -p Password -v ts=http: //Target. Server/reportserver -v tu="DomainUser" -v tp="Password"

Internet Corporate Network Client Devices AD DS AD FS Power BI Report Server Firewall Web Application Proxy Firewall

Configuring Options

Config. json C: Program FilesMicrosoft Power BI Report ServerPBIRSRSHosting. Serviceconfig. json

Server Properites (configurationinfo) SELECT * FROM dbo. Configuration. Info

Scale + HA/DR

PBI Report Server – Scale out deployment Report Server (Scaled-out) Load Balancer (rs. guyincube. com/reports) SQL Server (RS Databases) 1. Join secondary servers to deployment from first server configured 2. Backup encryption key on primary server and restore on all subsequent servers

PBI Report Server – HA/DR Report Server (Scaled-out) Load Balancer (rs. guyincube. com/reports) Connect to Listener***** SQL Server (Availability Group)

SSRS – Availability Group Failover Steps • Disable all SSRS jobs on old Primary • Restart Agent on new primary • Restart RS on all servers • Agent Jobs will be recreated on New Primary • Verify reports can run against new Primary

Configuring Kerberos

Step 1: Set RS authentication type File Location C: Program FilesMicrosoft Power BI Report ServerPBIRSReport. Serverrsreportserver. config <Authentication. Types> <RSWindows. Negotiate/> <RSWindows. NTLM/> </Authentication. Types> Don’t forget to restart the Report Server!!!!

Step 2: Set RS (Webserver) SPNs Manually Create HTTP SPNs if the Report Server is configured to use a Domain Account • Fully Qualified Domain Name (FQDN) | HTTP/machinename. domain. com • Net. BIOS | HTTP/machinename Open Power. Shell as administrator and run Setspn –a HTTP/machinename. domain. com domainaccount Setspn –a HTTP/machinename domainaccount

Step 3: Set SSAS SPNs Manually Create MSOLAPSvc. 3 SPNs if the Report Server is configured to use a Domain Account • Fully Qualified Domain Name (FQDN) | MSOLAPSvc. 3/machinename. domain. com • Net. BIOS | MSOLAPSvc. 3/machinename Open Power. Shell as administrator and run Setspn –a MSOLAPSvc. 3/machinename. domain. com domainaccount Setspn –a MSOLAPSvc. 3/machinename domainaccount

Step 4: Set SQL Browser SPNs Manually Create MSOLAPDisco. 3 SPNs if the Report Server is configured to use a Domain Account • Fully Qualified Domain Name (FQDN) | MSOLAPDisco. 3/machinename. domain. com • Net. BIOS | MSOLAPDisco. 3/machinename Open Power. Shell as administrator and run Setspn –a MSOLAPDisco. 3/machinename. domain. com domainaccount Setspn –a MSOLAPDisco. 3/machinename domainaccount

Step 5: Constrainted Delegation Settings for SSRS

Office Online Server

Host Excel Workbooks • Install Prereqs. • Install Office Online Server (OOS) on separate machine • Integrate with PBI Server • Add OOS machine acct as Admin to SSAS • Install Power. Pivot Instance

Embedding

What can you embed? • Paginated Report • Power BI Report • Excel • Mobile Report (don’t ask )

How do you embed? • Report Viewer Control • ? rs: Embed=true <html> <iframe src="http: //rs. guyinacube. com/reports/powerbi/Region%20 Sales? rs: Embed=true" height="100%" width="100%"></iframe> </html>

Rest API

REST API Manage report server catalog objects Successor to Reporting. Service 2010 SOAP API Documentation on Swagger. Hub

pleblanc@guyinacube. com asaxton@guyinacube. com