Schedule, Personalize and Deliver Power BI Reports Automatically

PBRS automates the complete reporting process—from scheduling and data-driven personalization to exporting and secure delivery. Generate the right report for every recipient across Power BI Service, Power BI Report Server, Power BI Paginated Reports and Microsoft SSRS—without repetitive manual exports or complex automation flows.

✓ Run reports on recurring schedules, custom calendars or business events
✓ Personalize filters, parameters, recipients, filenames and delivery messages
✓ Export complete reports and visual data to PDF, or export summarized and underlying visual data to Excel and CSV
✓ Securely deliver each output by email, Teams, SharePoint, FTP, cloud storage, printers and more

START FREE TRIAL BOOK A DEMO

PBRS automates the scheduling, personalization and secure delivery of Power BI reports in PDF and Excel formats.

Why Organizations Choose PBRS

Why Advanced Power BI Report Automation Needs More Than Native Tools

Native Power BI subscriptions and Power Automate can support straightforward report delivery. PBRS is purpose-built for reporting operations that must generate, personalize, package, protect and deliver high volumes of reports reliably from one centrally managed workflow.

Native Power BI and Power Automate

More Workflow Assembly as Requirements Grow

Built-in subscriptions and individually constructed flows can handle simpler requirements. More advanced reporting processes require additional actions, branches, services and ongoing maintenance.

Standard subscriptions are designed primarily for straightforward report-level delivery and recipients with the required Power BI access.

Recipient-specific reports can require loops, branches, filters, parameters and delivery actions to be created and maintained.

Multi-report packages require separate export, temporary storage, grouping, merge, archive and delivery steps.

PDF protection, document processing and structured or template-based Excel output may require additional tools, services or custom logic.

Custom calendars, business-event triggers and refresh-completion monitoring require additional trigger, polling and branching logic.

Different recipients and destinations can require separate connectors, routing conditions, filenames and message logic.

Power BI subscriptions can include a static page preview, but embedding exported output in a customized Power Automate email requires PNG export, image or HTML handling and testing across email clients.

Blank-report handling, failure notifications, retries and recovery actions must be designed and maintained separately.

API, licensing, capacity, connector, throttling and execution limits must be evaluated against the workload.

Reporting operations become distributed across flows, actions, connectors and external processing components.

PBRS

One Purpose-Built Reporting Workflow

PBRS brings scheduling, report generation, personalization, packaging, security, delivery and operational control into one centrally managed application.

✓

Run individual reports or complete packages on recurring schedules, custom business calendars or supported business events.

✓

Refresh Power BI datasets, monitor completion and then continue automatically into report generation and delivery.

✓

Use SQL or JSON data to burst reports and control recipient-specific reports, filters, parameters, formats and delivery rules.

✓

Assemble multiple reports as one email, encrypted ZIP, bookmarked PDF or multi-tab Excel workbook.

✓

Export complete reports or visual data to PDF, Excel, CSV and other supported formats, including formatted and template-based Excel output.

✓

Protect PDFs with passwords, encryption, permissions, watermarks and expiry controls before delivery.

✓

Deliver to external recipients by email, Teams, SharePoint, OneDrive, cloud storage, FTP, SFTP, network folders, Slack, printers and more.

✓

Embed report output directly in a customized email body as an image or HTML, personalize the surrounding message and optionally include a full report attachment.

✓

Detect blank reports, send notifications, apply configured retries and maintain execution and delivery history.

✓

Run within your Windows environment across Power BI Service, Power BI Report Server, Power BI Paginated Reports and Microsoft SSRS.

Choose PBRS when reporting must be personalized, packaged, protected and delivered at scale—not simply emailed on a basic schedule.

Explore PBRS by Reporting Requirement

Find the PBRS Workflow That Matches Your Reporting Need

Start with the requirement closest to your reporting workflow and see how PBRS manages the complete process—from scheduling and report generation to personalization, packaging, security and delivery.

Scheduling and Orchestration

Run Reports at the Right Time

Explore Power BI Report Scheduling →

Run reports on recurring schedules, custom calendars or business events.

Explore Dataset Refresh Automation →

Refresh datasets, wait for completion and then generate and deliver reports.

Explore Paginated Report Automation →

Automate parameters, exports and delivery for Power BI Paginated Reports.

Personalization and Packaging

Create the Right Delivery for Every Recipient

Explore External Report Delivery →

Deliver secure reports to customers and partners without requiring Power BI access.

Explore Personalized Report Distribution →

Control reports, filters, formats, security and delivery using recipient data.

Explore Power BI Report Bursting →

Turn one report into hundreds of individualized outputs automatically.

Explore Complete Report Packages →

Assemble multiple reports into one email, ZIP, PDF or Excel workbook.

Export and Delivery

Produce and Deliver Every Required Output

Explore Power BI to PDF Automation →

Schedule, personalize, combine, protect and deliver Power BI PDF outputs.

Explore Power BI to Excel Automation →

Create formatted, data-only, template-based and multi-tab workbooks.

Explore Automated Report Delivery →

Deliver reports through email, Teams, SharePoint, cloud storage, FTP and more.

Explore Automation Without Power Automate →

Replace complex reporting flows with one purpose-built PBRS workflow.

Package Schedules

Deliver Every Recipient’s Reports as One Complete Package

PBRS package schedules run reports from Power BI Service, Power BI Paginated Reports, Power BI Report Server and SSRS as one coordinated job.

✓

Run Standard Package Schedules

Run reports from Power BI Service, Power BI Paginated Reports, Power BI Report Server or SSRS from one schedule.

✓

Create Data-Driven Report Packages

Use database or JSON data to determine the reports, filters, parameters, recipients, formats, filenames, messages and supported delivery details required for each customer, account, department or location.

✓

Trigger Packages from Business Events

Coordinate multiple report schedules when a supported database, file, email or operational event occurs. Control the timing and execution order of the reports and tasks within the package.

✓

Deliver One Email, ZIP, PDF or Workbook

Send all completed files as attachments in one email, place them in one encrypted or password-protected ZIP, merge them into a bookmarked PDF, or consolidate applicable Excel outputs into one workbook.

✓

Personalize Every Recipient’s Package

Group completed reports by recipient so each customer or business unit receives one package containing only the reports and data intended for them, with the appropriate security and delivery instructions.

✓

Manage Package Exceptions Automatically

Detect and suppress blank reports, retry failed work, notify an operator or run alternative actions. Add pre-processing and post-processing tasks to support the complete reporting workflow.

PBRS replaces the repetitive process of exporting, renaming, collating, protecting and distributing individual reports with one centrally managed package workflow.

Explore Power BI to Excel Automation → Explore Power BI to PDF Automation →

One Reporting Workflow.
The Right Package for Every Recipient.

PBRS can use data to determine which reports each recipient receives, how every report is filtered and formatted, and where the completed package is delivered. One data-driven schedule can automatically create, collate and distribute a different report package for every customer, account, department or location.

✓

Select Package Contents from Your Data

Use database or JSON data to determine which reports belong in each customer, account, department or location package.

✓

Personalize Every Included Report

Apply the appropriate filters, parameters, formats, filenames, passwords and other supported settings to every report in the package.

✓

Group and Assemble Each Recipient’s Outputs

Collate reports for the same recipient and deliver them together, or merge applicable outputs into a bookmarked PDF or consolidated Excel workbook.

✓

Deliver Every Package Where It Belongs

Send each completed package in one email or ZIP, or route it to the appropriate folder, FTP location, cloud service or other supported destination.

One PBRS data-driven package can replace dozens—or hundreds—of separately maintained report schedules, subscriptions and delivery workflows.

Explore personalized Power BI report distribution →

PBRS creates, collates and delivers a different personalized Power BI report package for each recipient using data-driven rules.

Schedule Complete Report Packages—or Trigger Them When Business Events Happen

PBRS can run individual reports or complete multi-report packages on recurring schedules, custom business calendars or qualifying operational events. Reports are generated, assembled and delivered when your business process requires them—not merely at a preset time.

✓

Schedule Reports and Packages Around Your Business

Run reports hourly, daily, weekly or monthly, or use custom calendars, working-day rules, fiscal periods, holidays and month-end schedules.

✓

Trigger Workflows from Database Activity

Start a report or package workflow when qualifying database records are created, modified or deleted.

✓

Respond to Files, Emails and System Events

Run reporting workflows when a file appears or changes, a qualifying email arrives or another supported operational event occurs.

✓

Coordinate Event-Based Package Execution

Start and coordinate multiple report schedules and related tasks when a qualifying event occurs, with control over their timing and execution order.

✓

Refresh Datasets Before Reports Run

Refresh the required Power BI datasets, wait for the refresh to complete and then continue automatically into report generation, package assembly and delivery.

PBRS makes complete report-package creation part of the business process—not merely another recurring calendar task.

Explore advanced Power BI report scheduling →

PBRS runs individual Power BI reports or complete report packages on a schedule or in response to a business event.

Automated Report Distribution

Deliver Reports and Complete Packages Wherever Your Business Needs Them

PBRS automatically distributes individual reports, visual-data exports and assembled report packages in PDF, Excel, CSV and other supported formats. Deliver each completed output through the destination already used by the recipient or business process.

✓

Email and Microsoft Teams

Send individual reports or complete packages to the appropriate recipients, distribution lists or Teams channels. Multiple files can be delivered together in one email or packaged in a ZIP file.

✓

SharePoint and OneDrive

Place current reports, workbooks and completed reporting packages in the Microsoft locations used by your teams and business processes.

✓

Google Drive and Dropbox

Deliver exported reports and completed packages directly to configured cloud-storage locations without manually uploading each file.

✓

FTP, SFTP and Network Folders

Route reports and packages to secure transfer services, internal folders, customer locations and downstream operational systems.

✓

Slack, Printers and More

Support reporting workflows that extend beyond email, including collaboration platforms, specialist destinations and physical printing.

✓

External Report Recipients

Deliver complete reporting packages to customers, partners, suppliers and other external recipients without requiring them to sign in to Power BI.

The result: every recipient receives the complete reporting deliverable in the required format and destination—without manual exporting, collating, uploading or distribution.

Explore automated Power BI report delivery →

Power BI Dataset Refresh

Refresh the required Power BI datasets before report generation so every distributed report contains the latest available data.

Personalized Power BI Exports

Apply supported report bookmarks, Power BI filters and slicer selections automatically to create the correct report version for each recipient.

Blank Report and Package Checking

Detect empty reports before delivery and automatically omit them from individual deliveries or assembled report packages. PBRS can also retry failed report or package executions or run an alternative workflow when required.

Secure PDF Delivery

Protect PDFs with 128-bit encryption, separate owner and user passwords, data-driven security settings, detailed document permissions, text or graphic watermarks and expiry controls. Optional DRM can restrict access by approved email address, device count and permitted print attempts.

Secure Excel Workbooks

Apply static or data-driven passwords to personalized and combined Excel workbooks. Completed files can also be delivered in encrypted, password-protected ZIP packages or generated now and delivered later.

Custom Calendars

Schedule reports around fiscal periods, business days, holidays and custom patterns such as 4-4-5 calendars.

Failover

Automatically continue report processing on another server if the primary PBRS server becomes unavailable.

Distributed Processing

Distribute report workloads across multiple servers to deliver high report volumes within shorter reporting windows.

Audit Trail

Record who created, changed or ran reporting workflows—and when—for oversight, troubleshooting and compliance.

User & Group Security

Control PBRS access by user, group and role, with Active Directory integration for centralized administration.

REST API & Command Line

Let websites, business applications, external schedulers and scripts run applicable PBRS schedules and control scheduling services through the REST API. Use the command line to trigger schedules and obtain execution results.

Self-Service Web App

Let authorized users create and manage their own report schedules securely through a standard web browser.

Report History & Snapshots

Store and resend previous report outputs without rerunning the report, supporting history, recovery and audit requirements.

Monitoring, Alerts & Recovery

Track scheduled activity through queues, execution history and system monitors. Configure success or failure notifications, retry rules and exception actions when reports are blank or exports fail.

Pre- and Post-Report Workflows

Run supported programs, PowerShell, SQL scripts, database actions, file tasks or notifications before report generation, after production or after delivery to connect PBRS with wider business workflows.

Output Naming & Metadata

Create dynamic filenames and extensions, append run dates and times, and set applicable file-summary or SharePoint metadata to support search, classification, document management and downstream processing.

Secure Files & Deferred Delivery

Package supported report outputs in encrypted, password-protected ZIP files, deliver them through secure destinations such as SFTP, or generate reports at their scheduled time and defer delivery until later.

Email Delivery Controls

Send reports as attachments or embed supported reports in HTML or plain-text emails. Control recipients, sender account, subject and message content, and use data-driven inserts to personalize each delivery.

Common PBRS Use Cases

Reporting Workflows PBRS Is Built to Automate

PBRS is designed for recurring reporting operations where reports must be personalized, packaged, protected, triggered by business events or delivered beyond Power BI.

Customer and Partner Reporting

Generate separately filtered reports for customers, partners, franchisees or account holders, then deliver each version without requiring recipients to sign in to Power BI.

Finance and Board Reporting

Assemble financial statements, management reports, board books and supporting data into controlled PDF or Excel packages on recurring business calendars.

Operational and Exception Reporting

Run reporting workflows when database, file, email or other supported events occur, so teams receive information when an operational condition requires action.

High-Volume and Multi-Entity Distribution

Create high volumes of recipient-specific outputs using data-driven filters, parameters, formats, filenames, security settings and delivery destinations.

PBRS turns complex, recurring reporting requirements into centrally managed workflows that run consistently without repetitive manual exports.

Deployment & Access

Yes. PBRS is installed on a Windows server within your environment. Its application database can be hosted locally or in an enterprise SQL Server instance that you manage.

PBRS runs within your environment and uses the Power BI connections and accounts you configure. ChristianSteven does not host the PBRS application database or store your exported report data.

Microsoft’s Export To File API for ordinary Power BI reports requires Premium, Embedded or Fabric capacity and does not support PPU. PBRS, however, supports applicable Power BI Pro and PPU scenarios using alternative rendering methods. The licensing required still depends on the report source, authentication method and deployment configuration.

Yes. PBRS can export reports to files and deliver them to customers, partners and other recipients. Recipients of these exported files do not need to sign in to Power BI, although interactive access to the original Power BI report remains subject to Microsoft licensing.

Scheduling & Automation

Yes. PBRS supports hourly, daily, weekly, monthly, quarterly and annual schedules, along with working-day, holiday, fiscal and custom patterns such as 4-4-5 calendars.

Yes. PBRS can start reporting workflows when database records are created, changed or removed; when files appear or change; when qualifying emails arrive; and in response to other supported system events.

Yes. PBRS can initiate and complete a Power BI dataset refresh before generating the report, helping ensure the exported output contains current data.

PBRS can detect blank reports and suppress them, send them or start another workflow. Exception handling can also retry failed report executions immediately or at a configured later interval.

Personalization & Security

Yes. One data-driven schedule can repeatedly run the same report with different filters, slicer values, recipients, formats, filenames, messages and destinations.

Yes. Database tables and queries can dynamically determine recipients, filters, output formats, filenames, message content, destinations and other schedule settings at runtime.

Yes. PBRS can combine multiple Power BI, paginated or SSRS report outputs into one ordered PDF. It can also place data from multiple selected Power BI visuals into one worksheet, organize individual visuals on separate worksheet tabs, or merge Excel outputs from multiple reports into one workbook with each report on its own worksheet. With PDF Data Only output, data from multiple selected Power BI visuals can be placed on separate pages of one PDF.

Yes. PBRS can apply separate owner and user passwords—set statically or determined from data—and protect the document with 128-bit encryption. Permissions can control printing, full-resolution printing, copying, editing, filling fields, document assembly, adding notes and copying content for accessibility. PBRS also supports text or graphic watermarks, including company logos, plus expiry dates and custom expiry messages.

Optional PDF DRM can additionally restrict access by approved email address, limit the number of devices that can open the document and limit permitted print attempts. These DRM controls require a separate All-About-PDF Developer License.

Exports & Power Automate Limitations

PBRS supports PDF, Excel, CSV, Word, PowerPoint, HTML and image outputs, among others. Reports can be delivered through email, Teams, SharePoint, OneDrive, Google Drive, Dropbox, FTP/SFTP, network folders, Slack, printers and other supported destinations.

Yes. PBRS can select named Power BI visuals and schedule their summarized or underlying data for export to Excel or CSV, with up to 30,000 rows per visual-data export.

For larger datasets, PBRS can schedule a Power BI Paginated Report or SSRS report for export to Excel, with up to 1,048,576 rows per worksheet. This makes paginated and SSRS reports the appropriate option when the required Excel output exceeds the Power BI visual-data export limit.

Yes. Microsoft’s Export To File API limits an ordinary-report export job to 50 report pages or individual visual exports. PBRS can use its alternative rendering method to export ordinary reports exceeding that limit. Microsoft’s 50-export ceiling does not apply to paginated reports.

PBRS manages scheduling, rendering, status checking, retry handling, file creation and delivery within one purpose-built workflow. When PBRS uses its alternative rendering method, it is not subject to Power Automate connector throttling or its two-minute synchronous paginated-download limit. Actual throughput can still depend on Power BI capacity, server resources, network conditions, report complexity and data-source performance.

Yes. PBRS can create data-only or formatted Excel workbooks, control column headings, data types, Excel formats and selected row or column totals, and insert exported data into an existing template at a designated cell or the next available position. Multiple visual-data exports can be placed in one worksheet or organized on separate tabs, while report outputs can be merged into one workbook with each report on its own worksheet. Individual, personalized and combined workbooks can be protected with static or data-driven passwords before delivery.

“A great product! PBRS lets us create an enterprise-level solution to automatically generate up to 1,000 SSRS reports & distribute them to almost 5,000 users via email & print.

ChristianSteven has provided excellent support. In a recent case, even though the issue wasn't with PBRS your staff members took the time to identify the issue & come up with a couple of suggestions to resolve it.

ChristianSteven has also developed multiple custom features to meet our specific needs.”

Giles Chick

Senior Business Intelligence Developer, Uline

“PBRS - Reports Scheduling System from ChristianSteven, is a very well thought out product which really kept novice end-user in mind to create report schedules. It handles most of the report scheduling requirements out of the box.

The system handles both SQL Reporting Services & Power BI in a single solution which fits for our current and future needs. The support team is very easy to reach, and very professional. Product updates & patches are released every month, covering enhancement requests that they received from customers, which is nice!”

Arvind Periyasamy

Sr. Architect - Data & AI, Microsoft

“Overall, PBRS managed to deliver on all the functionality which it advertised. It is a great, easy to use tool which can do more than just deliver reports.

The YouTube channel was able to demonstrate the functionality and ease of use of the application, and the Knowledgebase documentation was thorough enough to allow us to use the software without any formal training.

The PBRS product support team were very prompt and helpful/responsive in resolving all issues which we encountered. ”

Paul Zamparo

Business Analyst, Healthcare of Ontario Pension Plan