---
id: post/bertverbeek-nl/1196
type: post
title: Data agent inside Fabric ask question on your Business Central Data
summary: Data Agents in Microsoft Fabric enable users to ask natural language questions about Business Central data without using APIs. The feature works with Mirrored Data sources for near real-time data synchronization and can be integrated into Copilot Studio for enhanced user experience.
tier: community
language: en
tags:
  - data agents
  - fabric
  - artificial intelligence
  - natural language queries
  - data synchronization
  - mirrored data
system: copilot
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:57:39.637Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 297c6395c8a3a4e29cd464364ae815638dd01726f8d1194c767de2013ed8beb7
evidence:
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/
    title: Data agent inside Fabric ask question on your Business Central Data
    date: "2025-12-19"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/
    title: Data agent inside Fabric ask question on your Business Central Data
    date: "2025-12-19"
    commit: null
    t: null
    quote: you can really easy create AI applications with your data and ask questions on your data
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/
    title: Data agent inside Fabric ask question on your Business Central Data
    date: "2025-12-19"
    commit: null
    t: null
    quote: if there is an huge demand of request your Business Central users won't affect it
  - kind: blog
    url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/
    title: Data agent inside Fabric ask question on your Business Central Data
    date: "2025-12-19"
    commit: null
    t: null
    quote: you almost get near real time data if you choose that option inside bc2adls to synchronize your date
links:
  learn: []
  objects:
    - object/table/18
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "1196"
source_id: bertverbeek-nl
source_name: Discover MS BC - Bert Verbeek
url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/
published_at: "2025-12-19T11:44:36.000Z"
author: Bert Verbeek
full_text: false
words: 284
quotes:
  - text: you can really easy create AI applications with your data and ask questions on your data
    why_it_matters: "Explains the primary capability: using natural language to query Business Central data without technical complexity"
  - text: if there is an huge demand of request your Business Central users won't affect it
    why_it_matters: Highlights the performance benefit of querying Fabric data instead of directly calling Business Central APIs
  - text: you almost get near real time data if you choose that option inside bc2adls to synchronize your date
    why_it_matters: Shows how Mirrored Data sources provide data freshness comparable to real-time requirements
code_objects_mentioned:
  - table Customer Ledger Entries
  - table Customer
systems:
  - copilot
  - integration
  - reporting
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/embed/
  image: https://www.bertverbeek.nl/wp-content/uploads/2026/02/d365businesscentral_512x512.png
  image_alt: null
  image_w: null
  image_h: null
  site_name: Discover Microsoft Business Central - The wonderful world of Business Central
  favicon: https://www.bertverbeek.nl/wp-content/uploads/2026/02/d365businesscentral_256x256.png
  probed_at: "2026-10-07T11:50:46.895Z"
---

# Data agent inside Fabric ask question on your Business Central Data

[Read the post](https://www.bertverbeek.nl/blog/2025/12/19/data-agent-inside-fabric-ask-question-on-your-business-central-data/) · Discover MS BC - Bert Verbeek (Bert Verbeek) · 2025-12-19 · 284 words · tier community · reviewed (checked by Opus)

> Data Agents in Microsoft Fabric enable users to ask natural language questions about Business Central data without using APIs. The feature works with Mirrored Data sources for near real-time data synchronization and can be integrated into Copilot Studio for enhanced user experience.

## Key points

- Fabric Data Agents answer natural language questions on Business Central data already stored in Fabric, without API calls
- Mirrored data sources synced with bc2adls give near real-time data
- Keep tables at 100 columns or fewer, or answer quality drops
- Agent instructions let it join tables, for example Customer Ledger Entries with Customer to group by City
- Querying Fabric instead of the MCP server or APIs keeps load off Business Central users, and the agent can be added to Copilot Studio

## Quotes

- "you can really easy create AI applications with your data and ask questions on your data" (Explains the primary capability: using natural language to query Business Central data without technical complexity)
- "if there is an huge demand of request your Business Central users won't affect it" (Highlights the performance benefit of querying Fabric data instead of directly calling Business Central APIs)
- "you almost get near real time data if you choose that option inside bc2adls to synchronize your date" (Shows how Mirrored Data sources provide data freshness comparable to real-time requirements)

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- table "Customer Ledger Entries"
- [table 18 "Customer"](../../objects/table/18.md)

Not found in BC28-30: table "Customer Ledger Entries".

## Context

- Features: Data Agents in Fabric, Mirrored Data sources, Natural language queries on Business Central data, SQL query generation, Agent configuration instructions, Table joins via agent instructions, Copilot Studio integration

Source: Discover MS BC - Bert Verbeek, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.