Guides

Install BC2Fabric

Follow this guide to configure the BC2Fabric table mirroring setup in Business Central and to install the BC2Fabric workload in Microsoft Fabric.

Before you begin

Make sure you have completed all prerequisites before installing BC2Fabric.

Configuring BC2Fabric Table Setup in Business Central

Use the BC2Fabric Table Config page to choose which Business Central tables will be mirrored to Fabric and to enable logging for incremental processing.

  1. In Business Central, use the search to open BC2Fabric Setup.
  2. In the Administration section, choose Mirroring Tables to open the BC2Fabric Table Config page.
  3. Under Tasks, select Set Default Setup. Around 250 reporting-relevant tables are added automatically.
  4. Ensure that the Mirroring flag is enabled for every table that should be replicated to Fabric.
Optional: Only if you need custom tables or custom queries. If you’re using the default setup, you can skip steps 6–8 below.
  1. Review the list and remove or add tables to match your reporting needs.
  2. When adding new tables or custom endpoints, select the Entity Set Name using the lookup (...) to choose from the available API query endpoints. The selected API must expose columns named systemRowVersion and systemId exactly.
  3. For custom tables or fields, generate API queries with the Query generator to ensure naming conventions align with the mirroring process.

Prefer to see the process in action? Watch the video below for a walkthrough of the table setup steps.

Installing BC2Fabric Workload in Fabric

Installing BC2Fabric in Fabric happens in two stages: first add the workload to your capacity or tenant, then install it inside the workspace where the mirroring should occur.

Add Workload to Capacity or Tenant

Assign the BC2Fabric workload to your Fabric capacity or entire tenant so that your Business Central data can be mirrored and stored in Fabric.

  1. Go to the Fabric workloads hub at app.fabric.microsoft.com.
  2. Search for the BC2Fabric workload or use the direct workload link.
  3. Select Manage - By Capacity and choose the capacities where BC2Fabric should become available or select "Add to entire tenant" to make it available in the entire tenant.
  4. Click update to complete the assignment.

Install Workload in Workspace

Open the workspace where you want the BC2Fabric mirroring to happen.

  1. Click New item, then select BC2Fabric under Get item.
  2. When prompted, enter a name for the workload (for example, BC2Fabric workload).
  3. In the workload page that opens, provide the following information (both from the prerequisites page):
  4. Click Install to start the setup. This will perform the following steps:
    • Validation to ensure a correct setup, access to Key Vault and Business Central
    • Creation of Mirroring database, pipeline and other relevant components
    • Initial full load from Business Central to Fabric
    • Activation of daily refresh schedule