PowerBI Report Server

Power BI Report Server is similar to SQL Server Reporting Services (SSRS). Power BI Report Server is on premises, and hosts paginated reports in addition to the Power BI features. There are several types of reports

• Paginated (standard SSRS type reports)
• Interactive (PowerBI Desktop)
• Mobile
• Analytical (Excel)

PowerBI Pro enables sharing and collaboration with the following features 

• Build dashboards that deliver a 360-degree, real-time view of the business
• Keep data up-to-date automatically, including on-premises sources
• Collaborate on shared data
• Audit and govern how data is accessed and used
• Package content and distribute to users with app

There is increased functionality within PowerBI Pro. A comparison between the free PowerBI desktop edition and Pro version is in the table below. Only Pro users can publish content to app workspaces, consume apps without Premium capacity, share dashboards and subscribe to dashboards and reports. Free users can connect to all data sources using connectivity options such as DirectQuery, live connection and use the data gateway. 

Licensing Power BI Report Server

Power BI Report Server is available in two different license modes: 

• Power BI Premium  
• SQL Server Enterprise Edition with Software Assurance.

A Power BI Premium license enables creation of a hybrid deployment (cloud and on-premises).

Capacity

The session delivered by Isabelle Van Campenhoudt at SQL Saturday Cambridge shared this useful capacity planning  paper. It is based on the sample Power BI Report Server topology using virtual machines. 

References

Pricing

PowerBI Free vsPro comparison

Comparing PowerBI Report Server and the Power BI service

What is PowerBI Report Server?

Capacity Planning

Microsoft SQL Server 2005 Reporting Services

SQL Server reporting services (subsequently SSRS) default install databases are:-

Database	Description
ReportServer	Report Server database is a SQL Server database that stores part of SSRS configuration, report definitions, report metadata, report history, cache policy, snapshots, resources, security settings, encrypted data, scheduling and delivery data, extension information and report execution log information. Note: Although users can certainly directly access databases in the SSRS catalog and directly modify objects that SSRS uses, this is not a recommended (or supported) practice. Underlying data and structures within the SSRS catalog are not guaranteed to be compatible between different releases of SSRS, service packs, or patches.
ReportServerTempDB	This database is responsible for storing intermediate processing products, such as cached reports (to increase performance), and session and execution data. Note To store temporary snapshots in the file system, instead of the database, administrators should complete the following steps. First modify RSReportServer.config and set WebServiceUseFileShareStorage and WindowsServiceUseFileShareStorage to True. Then set FileShareStorageLocation to a fully qualified path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\RSTempFiles. Unlike SQL Server's tempdb, data in ReportServerTempDB survives SQL Server and Report Server restarts. Report Server periodically cleans expired and orphan data in ReportServerTempDB. All data in ReportServerTempDB can be deleted at any time with minimal or no impact. The minimal impact that a user might experience, for example, is a temporary performance reduction due to lost cache data and a loss of an execution state. The execution state is stored in the table SessionData. Loss of the execution state results in an error: "Execution 'j4j3vfblcanzv3qzcqhvml55' cannot be found (rsExecutionNotFound)." To resolve the loss of the execution state, a user would need to reopen a report. TIP SSRS does not recover deleted ReportServerTempDB or tables within this database. To quickly recover from erroneous deletions of objects in this database, keep a script or a backup of an empty ReportServerTempDB handy.
RSExecutionLog	Additionally, the RSExecutionLog database can be added after the initial installation. This database stores additional logging information.