BC2Fabric - your Business Central data in Fabric
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.
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.