Dynamic & Data Driven Power BI Report Exports with Dataset Refresh.
Bring Dynamic Filters & Data Driven subscriptions to your Power BI reports distribution infrastructure.
- Trigger your Power BI Dataset Refresh before a report is exported, after it is exported, or both.
- Set Dataset Refreshes to happen as independent workflows (no link to report export).
- Use the data in your database to automatically & dynamically populate report filters, destinations, formats, email addresses, body text and much more, mass-generating, exporting and delivering separate Power Bi reports to individual recipients.
- Data Driven Packages make it easy to dynamically create report packs from multiple reports and send multiple report exports in the same email as a "package".
- Multiple Power BI PDF or Excel exports can even be automatically merged into one file; each report presented as a bookmark or a tab in the final PDF or Excel workbook.
- Data-drive and automatically set file metadata e.g. Author, Title, Subject, Tags and so on.
- Your corporate theme & culture are important, and so PBRS supports fully customized and full html email body formatting. The html code can be dynamic and data-driven too, allowing you to use different themes for different clients or departments!
Date-Time or Event Triggers? Have Both!
It's easy to schedule Power BI Dataset refreshes and report exports to run at a specific date and time; or to run them hourly, daily, weekly, or monthly; or set up your own custom frequencies e.g. 4-4-5, every other day, third Monday of the month, and so on. And the same report can be scheduled to be run multiple times with different filters, formats, frequencies, and destinations.
Distribute Power BI Reports and respond to your business needs by setting schedules to run based on events and triggers rather than date. For example, when a database record is created, modified or deleted; when data is received on a port; when an unread email exists in a folder in a mailbox; if a file exists; and so on.
The scheduling service runs as a Windows service to enable unattended scheduling. Simply set it & forget it!
PBRS' export process does not use Microsoft's export-to-file API so is not affected by the limitations & constraints of that API. For example, you can export reports that are more than 50 pages, and, unlike Power Automate, you do not need to be on a dedicated capacity Premium license to use PBRS.
PBRS works seamlessly with Power BI Service (Pro & PPU), PBiRS (Power BI Report Server - On Premises), Power BI Premium, and all editions of SQL Server Reporting Services (SSRS).
