Power BI Paginated Reports: Enterprise Guide 2026

Power BI Paginated Reports Enterprise Guide (2026)

Power BI Paginated Reports are the modern successor to SQL Server Reporting Services (SSRS), providing pixel-perfect, multi-page, formatted reports for invoices, financial statements, regulatory filings, audit reports, and operational documents that demand precise layout.

This is the working enterprise guide EPC Group uses for Fortune 500 Paginated Reports deployments — Power BI Report Builder authoring, Microsoft Fabric capacity sizing, RDL migration from SSRS, governance, sensitivity-label integration, and Microsoft 365 Copilot considerations.

EPC Group has delivered SSRS and Power BI Paginated Reports engagements for Fortune 500 healthcare, financial services, government, manufacturing, and technology since the SQL Server Reporting Services GA wave (2004) and through the Power BI Paginated Reports general availability.

TL;DR — When to Use Paginated Reports

Use Case	Why Paginated
Invoices, statements, receipts	Pixel-perfect, multi-page printable
Financial statements	Regulatory formatting requirements
Regulatory filings (10-K, 10-Q, EDGAR)	Pre-defined templates, reproducibility
Audit reports	Page numbering, headers/footers, formal structure
Compliance reports (HIPAA, SOC 2)	Templated, reproducible, legally-defensible
Operational documents	Bulk parameterized printing
Subscription reports	Scheduled email delivery

When NOT to use Paginated Reports: interactive dashboards (use Power BI reports), self-service exploration (use Power BI), real-time monitoring (use Power BI with DirectQuery or Real-Time Intelligence).

Architecture

Power BI Report Builder

Power BI Report Builder is the free authoring tool for Paginated Reports. It uses RDL (Report Definition Language) — the same XML-based format as SSRS, enabling:

• Direct migration from SSRS RDL
• Re-use of existing parameter, expression, and dataset patterns
• Co-existence with SSRS during migration
• Standard BIDS / SSDT / Visual Studio extensibility

Capacity Requirement

Paginated Reports require Microsoft Fabric capacity OR Power BI Premium Per User (PPU):

Tier	Notes
Microsoft Fabric F-SKU (F2+)	Paginated Reports supported
Power BI Premium Per User (PPU)	Paginated Reports supported
Power BI Pro	NOT supported
Power BI Free	NOT supported

Most enterprise Paginated Reports deployments run on Microsoft Fabric F-SKU capacity (F64+ for Power BI Copilot, F128+ for typical Fortune 500 mixed workloads).

Data Source Connectivity

Paginated Reports support broad data source connectivity:

• SQL Server, Azure SQL Database, Synapse, Microsoft Fabric Warehouse
• Oracle, Teradata, SAP HANA, IBM Db2 (via on-premises gateway)
• Power BI semantic models (DirectQuery)
• OData, REST APIs (via custom data connectors)
• Excel files, CSV files
• Web Service data sources (SOAP)

Phase 1: SSRS to Power BI Paginated Reports Migration

Migration Tooling

Microsoft provides:

• RDL Migration Tool — bulk migration of SSRS reports to Power BI service
• Reportbuilder /noprompt /pbi — command-line conversion
• PowerShell SQLServer module — programmatic migration

Migration Considerations

Most SSRS reports migrate cleanly. Common compatibility considerations:

• Custom code references (Code property in SSRS) — supported in Power BI Paginated, but some assemblies require update
• Custom report items — verify Power BI compatibility
• Linked reports — pattern differs in Power BI service (use parameter datasets instead)
• Custom datasets in Microsoft .NET assemblies — refactor to Power Query or T-SQL
• Email subscription delivery — migrate to Power BI subscriptions
• Snapshot rendering — migrate to scheduled refresh patterns

Phased Migration

EPC Group standard SSRS migration phasing:

• Phase 1 (Discovery): Inventory all SSRS reports, identify custom code, prioritize by business value
• Phase 2 (Pilot): Migrate 10-20 high-value reports, validate process
• Phase 3 (Bulk migration): Department-aligned waves
• Phase 4 (Subscription migration): Email subscriptions migrated to Power BI
• Phase 5 (Decommission): SSRS infrastructure decommission

Typical Fortune 500 timeline: 6-12 months for 1,000-5,000 SSRS reports.

Phase 2: Authoring Best Practices

Parameterization

• All filterable values as parameters (date range, region, customer ID, account)
• Multi-value parameter support for "select multiple" scenarios
• Cascading parameters (Region → Country → State)
• Default values for common scenarios
• Hidden parameters for technical use (server-side defaults)

Pixel-Perfect Layout

• Use rectangle containers for grouped layout sections
• Page header and footer with logo, page number, generation date
• Repeating row headers on tables that span pages
• Page break controls for multi-page reports
• Print-optimized margins and orientation

Performance

• Pre-aggregate at source rather than in report
• Use stored procedures for complex business logic
• Avoid expression-heavy column calculations (compute upstream)
• DirectQuery to Power BI semantic models for simple aggregations
• T-SQL for complex transformations

Accessibility

• Tab order for screen readers
• Alt text on images
• Keyboard navigation
• Color contrast (avoid red-only or green-only signals)
• Print-readable layout (don't rely on color alone)

Phase 3: Governance

Workspace Organization

• Department-level workspaces for ownership
• Hub-style workspaces for shared infrastructure (corporate templates, datasets)
• Capacity assignment based on usage patterns
• Sensitivity label inheritance from source data

Sensitivity Labels

• Inherited from source semantic model or data source
• Applied at report or dataset level
• Block external sharing of Restricted-tier reports
• Microsoft Copilot grounding scope respects label hierarchy

Row-Level Security and Data Source Security

Paginated Reports respect:

• Power BI semantic model RLS (when sourced from semantic model)
• SQL Server / Azure SQL row-level security (with EXECUTE AS user)
• T-SQL impersonation for source-side security

For multi-customer reports (sales territory, region, etc.), RLS is standard.

Subscription Management

• User-managed subscriptions (own report)
• Standard subscription delivery (PDF, Excel, Word, image)
• Email-based scheduled delivery
• OneDrive / SharePoint delivery
• Microsoft Power Automate integration for advanced workflows

Phase 4: Microsoft 365 Copilot Considerations

Copilot Grounding

Microsoft 365 Copilot does not currently natively explore Paginated Reports content (RDL files are not directly grounded). Common patterns:

• Generate Paginated Report PDF, store in SharePoint with sensitivity label, Copilot grounds on PDF
• Surface key Paginated Report data points in Power BI semantic model for Copilot grounding
• Use Microsoft Copilot Studio to wrap Paginated Reports as a custom Copilot agent

Power BI Copilot

Power BI Copilot focuses on interactive Power BI reports rather than Paginated. The differentiation is intentional:

• Power BI Copilot — natural-language report authoring, semantic model exploration
• Paginated Reports — pixel-perfect, regulated-format reproduction

Common Use Cases by Industry

Healthcare

• HEDIS measure reports
• CMS Star Ratings filings
• Joint Commission audit reports
• Patient financial statements
• Quality and safety reports
• Provider compensation reports

Financial Services

• Regulatory filings (Form 10-K, 10-Q, FOCUS, RegW, RegYY)
• FFIEC call reports
• Customer account statements
• Trade confirmations
• Compliance attestation reports
• Internal audit reports

Government

• Federal regulatory filings
• State agency reports
• Audit-defensible operational reports
• Federal grant reporting
• HHS / DHS / DOD operational reporting
• FedRAMP continuous monitoring reports

Manufacturing

• Supplier performance reports
• Quality control reports (CPK, defect rate)
• Plant operations reports
• Inventory aging reports
• Capital expenditure reports

Retail / CPG

• Store performance reports
• Vendor compliance reports
• Inventory turn reports
• Promotion effectiveness reports
• Loss prevention reports

Frequently Asked Questions

Should we use Paginated Reports or Power BI?

Use Paginated Reports for pixel-perfect, multi-page, regulated-format documents. Use Power BI for interactive analytics, dashboards, self-service exploration. Many enterprises use both — Paginated Reports for operational documents, Power BI for executive analytics. EPC Group standard: 80% of reporting needs are Power BI; 20% are Paginated Reports.

Do we need to migrate from SSRS?

For SSRS 2016/2017/2019/2022 on-premises: not strictly required (extended support continues), but Power BI Paginated Reports provides cloud benefits — Microsoft Entra ID identity, Microsoft Purview governance, Microsoft Sentinel auditing, automatic patching. Most Fortune 500 SSRS environments are migrating over 2026-2027.

What about SSRS hybrid?

Power BI Report Server (on-premises) provides SSRS-compatible deployment with Power BI integration. EPC Group recommends Power BI service over Power BI Report Server for new deployments — better cloud feature parity, fewer infrastructure obligations.

How much does this cost?

• Power BI Report Builder: free (authoring)
• Microsoft Fabric F64+ capacity: $5,800/month reserved (for Paginated Reports + Power BI Copilot)
• Power BI Premium Per User: $20/user/month (for organizations with under 200 Power BI users)

What about regulated industries?

Healthcare, financial services, government deploy Paginated Reports for regulatory and audit-defensible reporting. Sensitivity-label coverage, Microsoft Purview audit log retention, and Microsoft Sentinel monitoring are required for compliance posture.

Who delivers Paginated Reports engagements?

EPC Group senior architects with combined SSRS and Power BI experience since SQL Server 2000 / Power BI Project Crescent (2010-2013). Errin O'Connor was on the original Microsoft Power BI beta team and is a 4-time Microsoft Press author including a Power BI book.

Next Steps

Schedule a 30-minute Power BI Paginated Reports discovery call at /schedule or call (888) 381-9725. Senior architects (not sales) take discovery calls.

Related reading: Power BI Premium Pricing Licensing Guide, Microsoft Fabric Quickstart Assessment, Healthcare Analytics Power BI HIPAA Enterprise Guide, Government Analytics Power BI FedRAMP Enterprise Guide, and Power BI Report Automation Scheduled Refresh Guide.