Data agent inside Fabric ask question on your Business Central Data

Recently Microsoft Fabric launched Data Agents inside Fabric:
What’s New for Fabric Data Agents at Ignite 2025: Unlocking Deeper Data Reasoning and Seamless AI Interoperability | Microsoft Fabric Blog | Microsoft Fabric

With this capability you can really easy create AI applications with your data and ask questions on your data. Because allot of data is already in your Fabric you don’t have to hassle with API’s. Just select which data source you want and of you go!

And recently you can also access Mirrored Data sources. So in that case you almost get near real time data if you choose that option inside bc2adls to synchronize your date!

If you set it up please use note more then 100 columns inside your table otherwise your quality will drop.

So if you ask questions about the due dates from all customer ledger entries that are open you get it:

In the background it just does a SLQ query on your selected data:

But for example if you want to group by City (which column is not provided in the Customer Ledger Entries you get the following errors:

In that case you need to provide instructions to your agent:
Data agent configurations – Microsoft Fabric | Microsoft Learn

When that is done and if you ask it again:

Now the agent understands that he needs to make an Join with the customer table with the fields.

Benefits

Why would this benefits you in compare to just grab the MCP server or direct call the API’s?
Well the data is inside Fabric so if there is an huge demand of request your Business Central users won’t affect it. Also you can include it inside Copilot Studio: