| Features | Power BI Report Server | Notes |
| Analyze in Excel | No | Analyze in Excel |
| Bookmarks | No | Bookmarks in the Power BI service |
| Deployment | On-premises or hosted cloud | Power BI Report Server can be deployed in Azure VMs (hosted cloud) if licensed through Power BI Premium or SQL Server Enterprise with Software Assurance |
| Data sources | Cloud and/or on-premises | |
| License | Power BI Premium or SQL Server EE with Software Assurance (SA) | |
| Lifecycle | Modern lifecycle policy | |
| Release cycle | Three times a year (January, May, September) | Latest features and fixes come to the Power BI service first. A rollup of features from Power BI Desktop releases for the service comes to Power BI Report Server in each release; most other features are only meant for the Power BI service. |
| Composite models | No | |
| Connect to services like Salesforce | Yes | Connect to the services you use with template apps in the Power BI service. In Power BI Report Server, use certified connectors to connect to services. See Power BI report data sources in Power BI Report Server for details. |
| Create Power BI reports in Power BI Desktop | Yes | |
| Create Power BI reports in the browser | No | |
| Dashboards | No | Dashboards in the Power BI service |
| Distribute group of reports using apps | No | Create and publish apps with dashboards and reports |
| Dynamic M Query Parameters | No | |
| Export to Power Point (PPTX) | No | Export data for visuals to CSV or Excel options are available in Report Server. |
| Gateway required | No | |
| Host and connect to Power BI shared datasets | No | Intro to datasets across workspaces |
| Q&A | No | Q&A in the Power BI service and Power BI Desktop |
| Quick insights | No | Automatically generate data insights with Power BI |
| Paginated reports | Yes | Paginated reports |
| Personalize visuals | No | Consumers can customize visual type or data fields without modifying the report itself. |
| Power BI mobile apps | Yes | Power BI mobile apps overview |
| Real-time streaming | No | Real-time streaming in Power BI |
| Automatic page refresh for DirectQuery models | No | Automatic page refresh |
| ArcGIS for Power BI | Yes | ArcGIS for Power BI |
| Email subscriptions for Power BI reports | No | Subscribe yourself or others to a report or dashboard in the Power BI service |
| Email subscriptions for paginated reports | Yes | Subscribe yourself and others to paginated reports in the Power BI service |
| |
| Email delivery in Reporting Services |
| Data alerts | No | Data alerts in the Power BI service |
| Row-level security (RLS) | Yes | Available in both DirectQuery (data source) & Import mode |
| |
| Row-level security in the Power BI service |
| |
| Row-level security in Power BI Report Server |
| Many-to-many relationships | Yes | Apply many-to-many relationships in Power BI Desktop |
| Cross-report drillthrough | No | Use cross-report drillthrough |
| Full-screen mode | Yes | Full-screen mode in the Power BI service |
| R scripts and visuals | No | Create R visuals and run R scripts in Power BI Desktop and publish them to the Power BI service. You... |
| Python scripts and visuals | No | Create Python scripts and visuals in Power BI Desktop and publish them to the Power BI service. You ... |
| Preview features | No | |
| Power BI visuals | Yes | Power BI visuals |
| Power BI Desktop | Version optimized for Report Server, available for download with Report Server | Power BI Desktop for the report server |
| |
| Power BI Desktop for the Power BI service |
| Data Privacy Levels | No | Data Privacy Levels are available for reports in the Power BI service. In Power BI Report Server, use Role definitions. |
| Sensitivity Labels | No | Sensitivity Labels |
| Template apps | No | Install and distribute template apps in your organization |
