Customer Insights and SAP Integration in Fabric
Join us for our next Microsoft Fabric Meetup event on 13.11.2025. Agenda 18:00 – Arrive, grab a drink, and find your spot 18:15 – From Data to Decisions: Marketing Analytics with Dynamics 365, Power BI and Copilot Discover how to turn your marketing data into real business impact. In this session, we’ll explore how Dynamics 365 Customer Insights Journeys and Power BI work hand in hand to bring your marketing analytics to life. Customer Insights offers powerful out-of-the-box reports from email performance to journey analytics, but what if you want to go deeper? By combining your marketing data with sales or service information in Power BI, you can uncover new perspectives and measure what truly matters to your organization. And now, with Copilot and AI capabilities, understanding your data becomes even easier. We’ll show you how to ask natural questions about your campaigns, audiences and KPIs directly in Power BI or Customer Insights and get meaningful answers in seconds. You’ll leave this session with practical insights, best practices for connecting Customer Insights and Power BI, and examples of how AI can make data exploration more intuitive and impactful for marketers and sales teams alike. Speaker: Pauline Kolde - Manager @ Cluster Reply DE and Microsoft MVP, Björn Zahnow - Partner & Solution Architect @ CRMK Deutschland and Microsoft MVP 19:00 – Short Break 19:15 – Bringing SAP Data to Life in Microsoft Fabric: Event-Driven Integration with MirroredDB and ASAPIO Connecting SAP data to Microsoft Fabric just got smarter. In this session, we’ll explore how Open Mirroring and the ASAPIO Fabric Connector enable an event-driven data integration approach that keeps your Mirrored Database (MirroredDB) continuously in sync with SAP systems. Using Change Data Capture (CDC), Fabric maintains an exact copy of your SAP data - automatically reflecting changes as they occur, without the need for complex ETL or manual refreshes. We’ll dive into how this event-driven mirroring fits into a modern data architecture, ensuring consistency, governance, and scalability across your analytics landscape. Discover how Microsoft Fabric and ASAPIO together empower teams to unify SAP and non-SAP data -building a trusted foundation for analytics, AI, and data-driven decision-making. Speaker: Anis Fatnassi – Cloud Data Engineer @ msg, David Reger – Cloud Data Engineer @ msg 20:00 – Discussion & Drinks Engage with our speakers and participants in discussions while enjoying some refreshments. Don't miss this opportunity to enhance your Microsoft Fabric expertise, exchange ideas, and network with the community. We look forward to seeing you there!
[Azure Data Factory] Data Flow Sink is extremely slow
I'm copying about 800 items from SAP to Azure Fabric. I'm running pipeline with data flow in Azure Data Factory (ADF). We are using Self-hosted integration runtime. The Data Flow is not complex, it just copies data and adds an additional column. There are no complex transformations. However, the Sink activity takes around 10 minutes! Sink configuration: Sink type: dataset Dataset: Fabric warehouse Allow schema drift: true Allow insert: true Batch size: 100 Enable staging: false (I cannot turn it on; otherwise, I get an error in my pipeline: "Fabric DW supports staging only via copy command - EXE-0001, Dataflow cannot be analyzed as a graph.") I also tried using Copy activity as suggested here, but it keeps failing with a BULK insert error: Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=A database operation failed. Please search error to get more details., Source=Microsoft.DataTransfer.Connectors.MSSQL, ''Type=Microsoft.Data.SqlClient.SqlException, Message=Incorrect syntax near 'INSERT BULK'., Source=Framework Microsoft SqlClient Data Provider,' Some other observations: Sink processing time: 10m 33s Stage time: 7m 36s Table operations SQL duration: 2m 30s I also checked in the warehouse's long_running_queries and saw that INSERT was called 840 times, with each insert taking around 450ms. That means 800 * 450ms = 360,000ms (6 minutes)! My Question: Why is ADF inserting items one by one and ignoring the batch size of 100? Since I cannot enable Staging without errors and BULK insert fails, what is the correct configuration to load data from SAP to Fabric efficiently?
Connection to BW4HANA from Power BI
Dear team, Im triying to connect to sap bw4hana using .net connector as mentioned in microsoft help. I tried installing the highlighted 3.0 connector with option install "install assemblies to GAC" , i was able to connect to sap bw app server. but when i use recent data sources for next time. it throws below message more over nagivation is very very slow. how can i find implementation version is 1.0 or 2.0 and in connection page implementation options is not coming can anyone share the exact connector and download media. Regards, Selva
Training Resources for Manufacturing and Quality
Can anyone recommend any YouTube or other training resources for power bi reporting with a focus on maufacturing, technical and quality issues? Seems most of the training out there is geared towards sales and sales trending. Okay some of the senarios can be adapted but it would be easier for me to garner information where it relates more to what I am doing. Currently trying to do complaint trending using two different raw data sources, SAP and SQL (although with the SQL data I am only allowed to connect via access databases!). So having to merge the two lots of production data and skus etc. But would like to see ideal example of star schemas used for this type of trending, to give me some pointers. Currently using a denormalised table scraped from a report in access, along with data provided via launch bi.
SAP Business Warehouse Message Server data source not supported on Power BI report server?
Hello everyone, I am facing an issue with connecting to an SAP Business Warehouse Message Server data source on Power BI report server, and I would appreciate some advice from the community on how to resolve it. When I try to connect to the SAP Business Warehouse Message Server data source on Power BI report server, I receive an error message stating that the data source is not supported. However, I am able to connect to the same data source without any issues using the Power BI desktop application. I have tried several troubleshooting steps, including ensuring that the necessary drivers are installed on the report server, but none of these steps have resolved the issue. I suspect that this could be a compatibility issue between SAP Business Warehouse Message Server and Power BI report server. However, I am not sure how to confirm this or what steps I can take to resolve it. Has anyone in the community encountered a similar issue, and if so, what steps did you take to resolve it? I would appreciate any advice or suggestions on how to resolve this issue. Thank you in advance for your help.SAP General Ledger - Extract General Ledger Accounting Data to Power BI with Python Scripts
The Power BI Connector for SAP (PCS) from DVW Analytics can be used to extract data directly from SAP into Power BI Reports and Dashboards. In this blog series I will detail all the steps needed to extract data from SAP Tables and import the associated data into Power BI via Python Scripts generated in PCS where it can be easily refreshed.Extract SAP General Ledger - G/L Account Line-Item Display (T-code FBL3N) into Power BI
The Power BI Connector for SAP (PCS) from DVW Analytics can be used to extract data directly from SAP into Power BI Reports and Dashboards. In this blog series I will detail all the steps needed to extract data from a SAP Report as well as from SAP Tables and import the associated data into Power BI where it can be easily refreshed.
Convert SAP BO measure with Foreach() operator to DAX formula
Hi I'm pretty new to SAP BO and I'm trying to convert a measure that I've found in a report to DAX language. The foruma uses the context operator FOREACH() on two columns ([Data].[KPI Group] and Data].[KPI Name] ) and I don't know how to write it in DAX. Could you please help me figuring out? Here's the code: SUM( IF( [Not Available] FOREACH( [Data].[KPI Group];[Data].[KPI Name] )="Y" ) THEN 1 ELSE 0 ) Thanks
