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
- Slides: 35