Application Development
Cyber Security
Featured
Management Consultancy
1
Power BI
Generates PDF email
→
2
Cloud flow
Intercepts & extracts
→
3
Desktop flow
Downloads to local
→
4
.NET service
Converts PDF → PNG
→
5
Rich HTML email
Sent to recipients
BE
Author
Batoul Elbarbary
Read time
7 minute read
Published
7 Apr 2026
Topics
AI and Data Science
Executive summary
The problem wasn’t the data. It was the last mile of delivery.
Organizations invest millions in Power BI, yet executives consistently delayed reviewing reports — citing the friction of downloading and opening PDF attachments. Power BI’s native subscription mechanism provides only minimal low-resolution preview images, forcing recipients to open attachments to see full reports. For busy executives on mobile devices, this extra step was enough to kill engagement entirely.
OmniVista engineered a hybrid automation solution integrating Microsoft Power Automate (cloud and desktop flows) with a custom C# .NET Windows background service. The system intercepts Power BI subscription emails, extracts PDF attachments, converts them to high-resolution images, and constructs visually rich HTML emails with full report visuals embedded directly in the message body — all within the client’s secure on-premises infrastructure.
Report engagement increased by 67%, decision-making latency decreased by 3.2 business days, and the solution eliminated over 1,200 hours annually of manual report distribution — with a first-year ROI of 511%.
The challenge
Power BI’s last-mile problem
The client — a hedge fund with 2,500 employees across 12 regional offices — had deployed Power BI across all departments with 180+ dashboards. Despite this investment, executives consistently delayed reviewing reports. User interviews with 45 executives and managers revealed four critical limitations in Power BI’s native subscription feature:
Minimal preview images
Subscription emails include only a ~400x300px thumbnail — rendering dashboard details completely illegible.
Attachment dependency
Recipients must download and open PDF attachments. In high-security environments, attachment scanning adds 30–60 seconds per report.
No customisation options
Power BI provides no configuration to embed full visuals in email bodies or customise presentation format.
Limited branding
Generic Microsoft branding with no opportunity for corporate identity or contextual messaging.
Quantified business impact
Real-world impact
Three scenarios that defined the business case
The mobile executive
VP of Operations reviewing reports during her morning commute
Before
Blurry thumbnail → download 2.8MB PDF → wait 8 seconds on cellular → pinch-zoom to read metrics → give up → forget about it for 4 days.
After
Full dashboard visible in email instantly. Notices delivery dip. Taps Power BI link. Identifies West region issue. Sends message to regional manager. Issue resolved in 2 hours. Total time: 90 seconds.
The data-driven department head
Director of Sales receiving 12 Power BI subscriptions daily
Before
Each report takes 45 seconds to open due to security scanning. 12 reports = 9 minutes daily. He stopped opening them, missing early performance warning signs.
After
All 12 dashboards visible inline. Scanned in under 3 minutes. Anomalies spotted immediately. Early action prevents performance issues from compounding.
The cross-functional team
Supply chain team daily standups at 8:00 AM
Before
Nobody opened attachments before the meeting. Coordinator manually downloaded and screenshared reports — reintroducing the manual workflow Power BI was meant to eliminate.
After
Team members review embedded dashboard before 8AM meeting. Standups shorten by 11 minutes. Data-driven decisions made immediately. Inventory rebalanced before end of day.
Technical architecture
Five components, one orchestrated pipeline
OmniVista designed a hybrid automation architecture bridging cloud-based Microsoft Power Automate with on-premises .NET services — providing the flexibility and integration capabilities of Power Automate while maintaining complete data sovereignty through local processing and storage.
Component 01
Power BI subscription service
Native Power BI scheduled email subscriptions generate reports and send emails with PDF attachments to a dedicated processing mailbox (powerbi-automation@client.local).
Component 02
Power Automate cloud flow — email monitor
Monitors the processing mailbox via Microsoft 365 Outlook connector. Detects incoming Power BI subscription emails, extracts metadata (report name, timestamp, workspace), and triggers the desktop flow.
Component 03
Power Automate desktop flow — attachment handler
Executes on a dedicated Windows Server 2022 automation host. Downloads PDF attachments, saves to a monitored directory with standardised naming conventions, and logs processing metadata to SQL Server.
Component 04
PDFProcessorService — C# .NET Windows service
Continuously monitors the PDF input directory using FileSystemWatcher. Processes PDFs using PdfiumViewer at 300 DPI, extracts each page as high-resolution PNG, applies image enhancement via ImageSharp, and outputs processed images with companion JSON metadata files.
Component 05
Power Automate cloud flow — email composer
Monitors processed images directory. Dynamically constructs branded HTML email templates with base64-encoded images embedded inline. Resolves recipients from SharePoint distribution list and distributes emails with corporate branding and contextual messaging.
Implementation journey
Four technical challenges — and how each was solved
Challenge 01
PDF rendering quality
Initial PdfSharp implementation produced blurry text and jagged charts. Processing exceeded 45 seconds per page during peak hours.
Solution: Switched to PdfiumViewer (Google’s PDFium), achieving 3.2 seconds per page at 300 DPI — a 14x improvement — with full transparency and gradient support.
Challenge 02
Base64 email size limits
Embedding high-resolution images produced emails exceeding 25MB — triggering Microsoft 365 server rejection limits.
Solution: Adaptive DPI scaling (300/200/150 DPI based on page count) and intelligent JPEG compression reduced average email size to 4.2MB while maintaining visual quality.
Challenge 03
Desktop flow reliability
Desktop flows exhibited intermittent failures during peak hours. Outlook occasionally became unresponsive, causing 10-minute timeouts.
Solution: Dedicated Windows Server 2022 VM, Outlook cached mode, exponential backoff retry logic, and a PowerShell health monitor running every 5 minutes. Success rate improved from 91.4% to 99.7%.
Challenge 04
Concurrent processing race conditions
During peak hours (6:00–6:30 AM), 20–30 reports generated simultaneously caused file locking errors and duplicate email sends.
Solution: SQL Server distributed locking via a ProcessingStatus table eliminated race conditions and provided a full audit trail for compliance reporting.
Measurable outcomes
The numbers, 6 months after deployment
Email engagement
+112%
Open rate: 42% → 89% within 2 hours
Report consumption
+236%
Actual views: 28% → 94% (no download required)
User satisfaction
+53%
Score: 5.8/10 → 8.9/10 average
Time savings (annual)
Admin distribution eliminated322 hrs
Executive review time saved1,248 hrs
Meeting efficiency gains2,669 hrs
IT support tickets reduced 94%115 hrs
Total annual savings$354,800
ROI breakdown
Total implementation cost$58,040
Ongoing annual cost$7,752
First-year net benefit$296,760
First-year ROI511%
Payback period1.6 months
Security & compliance
On-premises by design — data sovereignty maintained
All processing occurs within the client’s secure on-premises infrastructure. The solution was validated by the client’s Information Security team prior to production deployment with no critical or high-severity findings.
Least-privilege access
PDFProcessorService runs under a dedicated service account with read/write access only to processing directories. No interactive logon rights.
Full audit trail
SQL Server ProcessingLog and EmailLog tables capture every action with timestamps, identities, and file metadata. Logs retained 7 years per corporate policy.
Data classification
Integration with Microsoft Purview ensures distributed emails carry sensitivity labels matching source Power BI report classification, enforcing encryption and forwarding restrictions.
Penetration tested
External security consultants found no critical or high-severity vulnerabilities. Two medium findings remediated before production launch.
SOC 2 validated
Architecture and controls mapped to SOC 2 Type II requirements. External auditors validated implementation during annual audit with no exceptions noted.
SIEM integration
Windows Server audit policies log all file access events in processing directories, forwarded to Splunk for correlation and alerting.
Future roadmap
What comes next
2 months
AI content summarisation
Azure OpenAI integration generating bullet-point summaries of key report insights above embedded visuals. Est. 40% reduction in review time.
1 month
Mobile-optimised responsive design
Responsive CSS frameworks optimising visual presentation across desktop, tablet, and mobile. Est. 25% increase in mobile engagement.
3 months
AMP interactive elements
Clickable chart elements and time period selectors within email clients — reducing need to open full Power BI reports by 30%.
2 months
Multi-channel distribution
Extending to Microsoft Teams adaptive cards, SharePoint, Slack, and SMS — meeting users where they already work.
Lessons learned
Key principles for enterprise automation success
⇄
Hybrid architectures win
Cloud-only solutions would have violated data sovereignty. On-premises-only lacked Power Automate’s connector ecosystem. Hybrid provided the optimal balance.
🛡
Reliability from day one
Logging, monitoring, retry logic, and health checks are not optional — they’re fundamental requirements for production-grade automation.
⚡
Performance requires iteration
Initial processing took 45+ seconds per page. Through profiling and library evaluation, this dropped to 3.2 seconds — a 14x improvement requiring systematic optimisation.
👥
User research drives outcomes
45 user interviews before designing the solution revealed that executives primarily review on mobile — fundamentally shaping the approach to image quality and email size.
🔒
Security as a collaborator
Engaging the security team during architecture design (not after development) prevented costly rework and resulted in only minor pre-production findings.
📊
Measure business outcomes
Technical metrics are necessary but insufficient. Tracking engagement rates, decision velocity, and ROI demonstrated true value to executive sponsors.
What users said — 60 days post-deployment
“Finally, BI reports that work like every other email. I can see everything on my phone without jumping through hoops.”
Regional Manager
“Our morning standups are so much more efficient. Everyone comes prepared because they’ve actually seen the data.”
Supply Chain Director
“I keep these emails in a folder and reference them throughout the day. With the old PDFs, I never kept them.”
Operations Manager
“The branded design looks professional. I actually forward these to clients now, whereas before I was embarrassed by the generic Power BI emails.”
Customer Success Manager
The problem wasn’t the data. It was the last mile of delivery. OmniVista closed that gap.
OmniVista · Application development · AI & Data Science
Struggling with Power BI report engagement in your organisation?
OmniVista builds custom automation solutions that bridge the gap between BI platforms and decision-makers.
