Resources

Changelog

Track releases and improvements for the BC2Fab Fabric workload.

Release history

Each entry below summarizes changes to the Fabric workload in BC2Fab.

Date Version Area Description
01.11.2025 V1.0 Fabric Workload Initial version of Fabric Workload.
20.11.2025 V1.1 Fabric Workload Performance- and stability improvements.
27.01.2026 V1.2 Fabric Workload New features:
  • New Tab "Tables" in BC2Fab workload showing all mirrored delta tables with last refresh timestamp and a reset-button to enforce a full refresh with schema update.
  • Improved full-loading implementation that keeps the delta tables intact during the refresh of endpoints that are defined with Load Type Full in Business Central for improved reporting consumption (especially relevant when using Direct Lake Mode).
  • Load-logging (aggregated logging with one row per load and detailed logging on table-company level) written into the internal lakehouse logs folder.
  • New delta table "Environment Information" is automatically created with information about the mirrored environment to allow displaying the environment name in reports.
28.01.2026 V1.3 Fabric Workload Hotfix for V1.2
25.02.2026 V1.4 Fabric Workload, BC App Renamed the solution and Fabric components from BC2Fabric to BC2Fab.
05.03.2026 V38 BC App

Synchronize BC2Fab Setup to other companies.

Query generator optimized:

  • Set GUID and version automatically.
  • Renaming and formatting of app.json.
20.03.2026 V39 BC App

Flowfields removed from out of the box API Queries to improve performance:

Table Name BC Field Name
Capacity Ledger Entry Direct Cost
Capacity Ledger Entry Overhead Cost
Item Ledger Entry Cost Amount (Actual)
Item Ledger Entry Cost Amount (Expected)
Item Ledger Entry Sales Amount (Actual)
Item Ledger Entry Sales Amount (Expected)
Job Task Start Date
Job Task End Date
Sales Line Posting Date
31.03.2026 V40 BC App New API endpoints TableInformation and RowVersionInfo. TableInformation shows the number of rows of each BC table.
08.04.2026 V41 BC App Improved deletion logging for multi-company scenarios.
09.04.2026 V42 BC App Performance and stability upgrade.
28.04.2026 V1.5 Fabric Workload New features & improvements:
  • BC Model Accelerator — generates a bc_silver schema on top of the raw mirrored bc tables. The Metadata Engine reads BC key and relation metadata and emits CREATE OR ALTER VIEW statements for every BC table. Each view preserves all original columns and adds deterministic surrogate-key columns (e.g. Sales Line ID (PK), Item ID (No.)) with a company prefix for multi-company support. Conditional foreign keys (e.g. Sales Line → Item / Resource / G/L Account) are resolved via CASE WHEN on the Type field, producing single-column relationships that are Direct Lake compatible and navigable by AI agents.
  • Robustness improvements: reliable handling of late-arriving BC data to prevent stale or missing rows when BC API responses are delayed or arrive out of order.