Edit

Set up data mirroring from Business Central to Microsoft Fabric

[This article is prerelease documentation and is subject to change.]

Use the Connect to Microsoft Fabric assisted setup guide to connect Business Central online to an open mirrored database in Microsoft Fabric. Choose the Business Central companies and tables to synchronize, and make their data available in OneLake for use with Fabric IQ, Power BI, Data Factory, and other analytics experiences.

Important

  • This feature is planned to become available as a production-ready preview in October 2026. Delivery timing and functionality might change.
  • Production-ready previews are subject to supplemental terms of use.

Prerequisites

Before you begin, make sure the following requirements are met.

Business Central requirements

  • Your Business Central online environment is running 2026 release wave 2, version 29.0 or later.
  • The Microsoft Fabric Mirroring extension is installed from Microsoft Marketplace.
  • Data encryption is enabled. Business Central stores the app's client secret in encrypted isolated storage.
  • Your user has the MS Fabric Mirroring - Admin permission set or equivalent permissions.

For the current preview, you also need a dedicated app registration in Microsoft Entra ID. During setup, you enter its application (client) ID, client secret, and service-principal object ID, which Business Central labels Principal ID. Refer to Register an application in Microsoft Entra ID for Business Central data mirroring

Microsoft Fabric requirements

  • You have access to an active Microsoft Fabric capacity.
  • You are a Member or Admin of the Fabric workspace so that you can add the mirroring service principal.
  • The Fabric workspace is in the same Microsoft Entra tenant as your Business Central environment.

Learn more in Create a workspace.

Register an application in Microsoft Entra ID for Business Central data mirroring

For the preview, create a dedicated app registration in Microsoft Entra ID for Business Central data mirroring. By using a dedicated registration, you limit the permissions and credentials to this integration.

  1. Sign in to the Microsoft Entra admin center.

  2. Create the app registration:

    1. Browse to Microsoft Entra ID > App registrations > New registration.

    2. In the Name field, enter a meaningful name for the app, such as BC mirroring to Fabric.

    3. Set the Supported account types field to Single tenant only unless you need Multiple Entra ID tenants.

    4. Under Redirect URI set Select a platform box to Single-Page application (SPA). Set the URL box to the Business Central web client base URL + /OAuthLanding.htm, like https://businesscentral.dynamics.com/aaaabbbb-0000-cccc-1111-dddd2222eeee/Production/OAuthLanding.htm.

      If token acquisition fails, the error shows the exact redirect URL that you must register.

    5. Select Register.

    The app's Overview page is displayed. Copy the Application (client) ID for later.

    Learn more in Register an application in Microsoft Entra ID and How to add a redirect URI to your application.

  3. Add the Fabric API permission:

    1. Select API permissions > + Add permission.
    2. On the Microsoft APIs tab, select Power BI Service > Delegated permissions.
    3. Select the Workspace.ReadWrite.All checkbox, and then select Add permissions.
    4. Select Grant admin consent for your tenant.

    Learn more in Configure app permissions for a web API.

  4. Add a client secret for the registered app.

    1. Select Certificates & secrets > Client secrets > New client secret.

    2. Fill in the description, select an expiration option, and then select Add.

    3. Before you leave the Certificates & secrets page, copy the secret's value to a temporary location. The value isn't accessible once you leave the page. You enter the secret value in the Business Central assisted setup.

      Learn more in Add credentials to your web application.

  5. Get service principal object ID:

    1. On the Overview page, select the link next to Managed application in local directory. This action opens the corresponding Enterprise application, which is the service principal for your app registration.
    2. On its Overview page, copy the Object ID.

Prepare an open-mirrored database in Microsoft Fabric

Before you configure mirroring in Business Central, prepare the destination in Microsoft Fabric.

  1. Sign in to Microsoft Fabric.
  2. Open the workspace that will contain the Business Central data. If you don't have a workspace, learn more in Create a workspace.
  3. Create a Mirrored Database item.
  4. Enter a name for the database.
  5. For the data source, select Open Mirroring.
  6. Create the database and wait until Fabric finishes provisioning it.

Learn more in Open mirroring in Microsoft Fabric. For the complete Fabric procedure, see Tutorial: Configure Microsoft Fabric open mirrored databases.

Configure mirroring in Business Central

After Fabric provisions the open-mirrored database, return to Business Central and use the Connect to Microsoft Fabric assisted setup guide to select the workspace and database, grant the service principal access, and configure the companies and tables to synchronize.

  1. Sign in to Business Central.

  2. Select Search (Alt+Q) in the upper-right corner Assisted Setup, and then choose the related link.

  3. Select Connect to Microsoft Fabric.

  4. On the Workspace API Credentials step, enter the Client ID, Client Secret, and Principal ID.

  5. On the Fabric Workspace step, use the lookup to select the destination workspace.

  6. On the Grant Workspace Access step, select Add to workspace.

    Business Central adds the service principal as a Contributor to the selected workspace. You only need to grant this access once for each workspace.

  7. On the Fabric Open Mirroring Database step, select the database that you created.

  8. On the Synchronization Options step, enter the interval between synchronization runs.

  9. Select Select companies, and add each company whose data you want to synchronize.

  10. Select Select tables, and add the tables to synchronize.

  11. Select Connect to Fabric.

    Business Central starts the mirroring setup process asynchronously. You can continue with the guide while setup runs.

  12. Finish the guide. Start synchronization when you're ready to replicate the selected data to OneLake.

Verify the mirroring setup

Open the Microsoft Fabric Mirroring Setup page, and check the following fields:

  • Fabric Workspace Name
  • Fabric Open Mirroring Name
  • Fabric Data Namespace
  • Fabric Logging Namespace
  • Setup Complete
  • Export Enabled

Select Test connection to verify that Business Central can access the Fabric API with the stored credentials.

The default data namespace is BusinessCentral. The default logging namespace is BusinessCentral_log. You can change the namespaces before the mirroring setup finishes.

Secure the Fabric connection

Business Central shows a privacy notice before it accesses Microsoft Fabric. An administrator must approve the notice before the connection or synchronization can start.

Treat the client secret as a credential. Don't share it or include it in screenshots, support requests, or exported configuration packages. To replace the secret, enter the new value on the Microsoft Fabric Mirroring Setup page.

Find free e-learning modules for Business Central here

  • Last updated on