Guides

Create BC Queries

Use the BC2Fabric query generator in Dynamics 365 Business Central to build AL queries that surface the tables and fields you need inside Microsoft Fabric.

Generate custom queries with BC2Fabric

The guided workflow helps you pick tables, include the right fields, and export a ready to deploy AL package. Watch the walkthrough below to see the end-to-end process.

Key steps highlighted in the video

  • Use BC to Fabric Setup page and launch the query generator task.
  • Choose the tables that should be exposed to Fabric and fine-tune included fields.
  • Export the generated AL app package and publish it to your Business Central tenant.

With the generated queries in place, refresh the Fabric workload so the new data appears in your Lakehouse and Power BI datasets.