22-25 April 2026

From SAP Extracts to AI-Powered Insights with Business Process Solutions

Proposed session for SQLBits 2026

TL; DR

Unlock SAP data with Business Process Solutions for Fabric. Live demo shows automated deployment of lakehouses and reports, AI-assisted customization via MCP servers, and conversational agents in Teams. Learn to compress weeks of development into days.

Session Details

Finance teams face a persistent challenge: critical data remains locked in SAP while traditional approaches require weeks of IT involvement to extract data, build pipelines, and develop reports. This results in stale information that hampers decision-making and prevents deployment of AI-powered analytics.

This session demonstrates how Microsoft's Business Process Solutions transforms this paradigm by automatically deploying complete data infrastructure for modern financial reporting. Attendees will see live demonstrations of Business Process Solutions connecting SAP to Microsoft Fabric, automatically creating lakehouses, data pipelines, and production-ready financial reports without manual development.

The session then explores how AI assistance through the Power BI MCP Server enables finance professionals to customize pre-built solutions to match organizational requirements. We'll demonstrate adapting hierarchical structures to tabular formats, incorporating reporting standards like IAS 1, and building custom calculations—compressing weeks of specialized development into hours.

Finally, we'll demonstrate deploying Fabric Data Agents into Microsoft Teams for conversational access to live SAP data, and integrating Finance Agents for Excel and custom agents built in Copilot Studio.

Participants will leave with a practical roadmap for transitioning from static, extract-based reporting to live, AI-augmented financial intelligence.

3 things you'll get out of this session

Deploy Business Process Solutions to automatically create complete Fabric infrastructure for SAP financial data without manual development. Use MCP servers and AI assistance to customize pre-built SAP solutions to match organizational reporting requirements and standards. Build and deploy conversational AI agents (Teams, Excel, Copilot Studio) for natural language access to (near) live SAP financial data.

Speakers

Rishi Sapra

rishisapra.com