SAP Business Process Solutions for Microsoft Fabric — End-to-End Setup to Power BI
Episode #314
Introduction
` In episode 314 of our SAP on Azure video podcast we talk about SAP Business Process Solutions for Microsoft Fabric and how to move from SAP source data to an analytics-ready end-to-end setup.
Together with Bartosz, we break down the practical flow: setting up connectivity, selecting tables and CDS views, using prebuilt models and pipelines, and extending the solution with customer-specific requirements like Z tables.
We also discuss why this template-based approach helps customers avoid common integration pitfalls and reach a working Power BI result faster, while still leaving room for custom extensions.
Find all the links mentioned here: https://www.saponazurepodcast.de/episode314
Reach out to us for any feedback / questions:
- Goran Condric: https://www.linkedin.com/in/gorancondric/
- Holger Bruchelt: https://www.linkedin.com/in/holger-bruchelt/
#Microsoft #SAP #Azure #SAPonAzure #MSFabric #Data #PowerBI #Copilot
Summary created by AI
- Business Process Solutions Overview:
- Holger and Bartosz explained that Business Process Solutions provides prebuilt Fabric data models, pipelines, transformations, and dashboards to accelerate SAP and other business-application analytics, with finance, sales, and procurement currently covered and the product generally available.
- Customer Value: Bartosz described Business Process Solutions as a Fabric workload that establishes reusable foundations for bringing SAP data into Microsoft Fabric for analytics, AI processes, and agent scenarios. It provides prebuilt business-entity models, such as a general-ledger model containing accounting documents, company codes, GL accounts, and debit/credit information.
- End-To-End Assets: The solution includes data-ingestion pipelines, transformation notebooks, environments, mappings, and prebuilt Power BI dashboards. These assets process source data into a form compatible with the Microsoft ecosystem and can produce ready-to-use views such as financial statements.
- Broader Application Scope: Holger and Bartosz noted that the approach is not limited to SAP. Business Process Solutions is intended to consolidate data from systems such as Salesforce, Oracle, Dynamics, and ServiceNow in Fabric; current business-process coverage includes finance, sales, and procurement, while additional areas may be prioritized based on customer demand.
- General Availability: Bartosz stated that Business Process Solutions is generally available and supported as a Microsoft product that customers can use to accelerate analytics with business-application data.
- SAP Connectivity And Onboarding:
- Holger and Bartosz reviewed the tutorial’s from-scratch setup, including Fabric workspace configuration, source-system selection, and several supported methods for connecting SAP data to Business Process Solutions.
- Initial Configuration: The recorded walkthrough starts with an empty Fabric environment, creates the required workspace, configures Business Process Solutions, and connects it to an SAP system.
- Connection Options: Bartosz demonstrated the copy job for SAP via ABAP Add-On, noting that the shown connection path was in preview and that customers could sign up to enable it. He also confirmed support for partner-integrator solutions and SAP Datasphere when customers prefer those approaches.
- Partner Integration: Customers using a preferred partner solution can contact the Business Process Solutions team through the feedback or request form. Existing partners can provide accelerators and ready-to-use packages that send data into Business Process Solutions.
- Connectivity Guidance: Bartosz said the team aims to support the simplest practical way for each customer to bring SAP data into Fabric. The three emphasized approaches were Microsoft-native connectivity, the partner ecosystem, and SAP Datasphere; customers can also report missing connectivity options for consideration.
- Scenario Selection And Data Models:
- Bartosz showed how customers select a business insight such as financial reporting, after which Business Process Solutions deploys the associated dashboard, source objects, data model, and processing logic.
- Insight Selection: During configuration, customers choose the business scenario or dashboard they want to enable, such as a financial or sales dashboard. The selection determines which SAP tables or CDS views are extracted and processed.
- Prebuilt Templates: The templates specify the required source data, how objects are joined, how transformations are performed, and how results are visualized. They provide a working starting point rather than requiring customers to independently identify and connect every relevant SAP table.
- Semantic Modeling: Bartosz explained that the deployed models define relationships among objects such as company codes, GL accounts, and cost centers. The solution addresses SAP-to-Power BI incompatibilities, including composite-key relationships that Power BI does not directly support.
- Hierarchy Handling: SAP hierarchies are transformed into flattened structures suitable for Power BI. This allows hierarchical business data to be used consistently in the resulting semantic model and dashboards.
- Replication And Data Processing:
- Holger and Bartosz walked through the replication path from SAP into Fabric’s bronze, silver, and gold layers, including extraction, transformations, relationship creation, hierarchy flattening, currency conversion, and Power BI refresh.
- Bronze Extraction: After the source connection and scenario are selected, Business Process Solutions creates a ready-to-use copy job that extracts the required SAP objects into a bronze lakehouse. This avoids manually maintaining the complete object list.
- Incremental Processing: Bartosz noted that future incremental-extraction capabilities will include configuration such as watermarks and relevant fields or queries for incremental retrieval. The goal is to avoid the substantial manual effort of designing extraction logic separately for many tables.
- Silver Processing: The silver stage transforms the extracted data and adds required columns. The tutorial shows how the source data is inspected and processed before it is prepared for the analytical model.
- Gold Processing: The silver-to-gold stage creates physical relationships, assigns surrogate keys, imports foreign keys, flattens hierarchies, and performs currency conversion. Once complete, the gold lakehouse can serve as the source for a refreshed Power BI dashboard.
- Extensibility And Customer Collaboration:
- Bartosz emphasized that the provided models and processing assets are starting points that customers can extend, while the product team uses customer feedback to prioritize additional integrations, processes, and capabilities.
- Model Extensions: Customers can extend predefined models with additional customer-specific tables and can define their own data models for scenarios not covered by the standard solution.
- Open Assets: Pipelines and notebooks are available for customers to inspect and modify. Customers can change pipeline behavior or add custom cleansing and processing logic in notebooks while retaining the provided templates as a foundation.
- Optional Adoption: Customers may use the full end-to-end solution, use only the data models and copy-job templates, or reuse the Power BI reporting examples. The assets are intended to accelerate work regardless of how much of the packaged solution is adopted.
- Feedback And Roadmap: Bartosz invited customers to request support for areas such as inventory and forecasting, as well as additional connectivity and business processes. The team evaluates customer demand and collaborates with customers to enable missing capabilities.
- Tutorial And Documentation Guidance:
- Holger and Bartosz positioned the two-hour recording and related documentation as practical references for customers implementing the solution, with chapters allowing viewers to jump directly to the relevant implementation stage.
- Video Structure: Holger explained that the recording covers the complete process from an empty Fabric environment through SAP connectivity, replication, transformation, and a final Power BI dashboard. Viewers can use the chapters to navigate directly to stages such as bronze-to-silver processing.
- Documentation Use: Bartosz recommended reading the official documentation alongside the video because specific procedures may apply to SAP Datasphere integration, Open Mirroring, or the ABAP copy job. The recording provides implementation examples and tips, while the documentation supplies the applicable connection-specific instructions.
- 0:00 Intro
- 0:28 SAP Insider takeaways and the Fabric integration question
- 1:44 What SAP Business Process Solutions (BPS) is
- 2:56 Prebuilt data models, dashboards, and accelerators
- 4:10 Handling SAP hierarchies for Power BI
- 7:01 Starting from scratch in Microsoft Fabric
- 7:45 Connecting to SAP with ABAP copy job
- 8:33 Datasphere and partner connectivity options
- 11:00 BPS configuration and selecting SAP tables/CDS views
- 13:27 Preconfigured relationships in the data model
- 15:16 Extending with customer-specific Z tables
- 16:06 Ready-to-use copy job and incremental extraction roadmap
- 18:24 Bronze–Silver–Gold processing, keys, and currency conversion
- 20:52 Best-practice template approach for customer projects
- 22:27 Wrap-up and where to find the detailed walkthrough
