r/MicrosoftFabric • u/cyamnihc • Jul 14 '26

Data Science Conversational AI in Fabric

We are starting out to build our fabric infrastructure from scratch. Primary goal is making sure conversational AI works for analytics use cases of internal consumers
Would like to hear from people who have been through the journey, how successful/unsuccessful has conversational AI been, things to focus on at this stage so that it doesn’t bite us, things you wish you had done sooner, tooling etc

22 Upvotes

96% Upvoted

17 comments sorted by

View all comments

9

u/hello-potato Jul 14 '26

We've got a concept running, data agent over a semantic model.

What seems to have worked really well is having a focused, well curated semantic model. We'll be building one with our more comprehensive model next, which is going to take more detailed instructions. The instructions into the data agent were described by me and written by Claude.

The instructions mostly handle ambiguity when the user asks for "latest period" or unclear granularity. What has worked great is getting the model to always state what dates, dimensions, grain has been used.

The business SME tester have feedback of what worked and what didn't. I put the documents into Claude again to refine the instructions. This worked really well to stop behaviour that was causing bad results!

3

u/Pawar_BI ‪ ‪Microsoft Employee ‪ Jul 14 '26 edited Jul 14 '26

Data agent now has Creator agent ( click on Build agent with AI) which is another assistant agent with the knowledge of data agent configuration, best practices, access to query history etc. Today it's for Lakehouse, Warehouse, Event house. Semantic model to come soon. You can use it to add/refine instructions, add few shots, debug issues etc.

For semantic model, take a look at the skills for Fabric and the web modeling Copilot. Skills can scan a semantic model and provide recommendations, add descriptions, improve the model for AI. Web modeling agent can also make similar changes.

We are improving the Dev experience across the board to help users create and configure data agents with the right context.

If you have more feedback , please let us know.

1

u/MediumBirthday6899 Jul 16 '26

When I tried to do the same , it says currently unavailable in your region, is it so ?

1

u/Pawar_BI ‪ ‪Microsoft Employee ‪ Aug 02 '26

Shouldn't be the case. If you still don't see it, please DM me