BC2Fabric - your Business Central data in Fabric
Organizations using Microsoft Dynamics 365 Business Central have incredible data at their fingertips—but turning that data into actionable insights can be challenging. Many existing solutions are rigid, difficult to extend, and not built for the flexibility and scale modern businesses require.
BC2Fabric offers a better way.
With a seamless, no-code integration, it brings your Business Central data directly into Microsoft Fabric—automatically, securely, and in real time.
Built for performance, BC2Fabric handles even multi-million-entry tables effortlessly. Whether you're consolidating data from multiple companies, enriching it with external sources, or scaling your reporting, BC2Fabric adapts to your needs.
What makes BC2Fabric unique:
It combines the best of both worlds—the flexibility and performance of the pre-SaaS era, where direct SQL access allowed full control and speed, with the security, flexibility and governance of today’s cloud world, powered by standardized APIs and Microsoft’s modern data platform.
BC2Fabric
Highly automated access of your Business Central data in Fabric.
Win insights only minutes after installation from AppSource
BC2Fabric - in a nutshell:
BC2Fabric is an easy and powerful way to connect Microsoft Dynamics 365 Business Central with Microsoft Fabric. Whether you manage a single company or multiple entities, BC2Fabric empowers you to turn raw ERP data into actionable insights — in near real time.
The goal of BC2Fabric: Gain transparency into your business without the hassle to build complex interfaces.
From sales, finance and inventory to projects and production — BC2Fabric ensures your Business Central data is always where you need it: live, centralized, and ready for action.
BC2Fabric - features
Near Real‑Time Data Sync — Automatically stream all relevant data from Business Central into Microsoft Fabric without delays
Multi‑Company Integration — Combine data from multiple companies or tenants in one central data platform.
Augment with External Data — Extend your Business Central data by merging it with other sources in Microsoft Fabric — for deeper, smarter analysis.
Instant Reporting with Power BI — Build live, real‑time dashboards and reports directly on top of your Microsoft Fabric lakehouse. No additional data movement is required thanks to Fabric's Direct Lake Mode.
Extensive content: Around 10.000 fields from 250 most relevant Business Central tables are available out-of-the-box. The content can easily be extended by additional tables and fields.
Easily build your custom reports: As a result of having all relevant Business Central data available in the lakehouse, developing new Power BI data models and reports becomes much faster easier.
Zero Coding Required — Fully configurable with an intuitive interface — no developers needed.
Data historization: data from fluid source tables (such as Sales Orders) will be historized in the lakehouse for ex-post analysis.
Automatic translation of fields, option values etc. into all supported languages.
Supported areas of reporting
Finance
Clear presentation of your profit and loss statement as well as balance sheet with insights into further details such as the income statement by cost centers or any other dimensions
Purchase
Analysis of your procurement with metrics such as purchase volume, price trends, supplier diversification, purchasing volume with and without order reference, etc.
Inventory
Enhance your understanding of inventory status by leveraging key metrics, including inventory value, inventory days, on-time percentage, and purchase and sales amounts.
Sales
Comprehensive insight into your sales with metrics such as revenue, order intake, sales forecast, contribution margin, discount, new customer revenue, etc.