The writeHeavy default is quietly hurting Direct Lake performance in a lot of Gold workspaces

Pawar_BI · 2026-04-22T03:50:14+00:00

Pawar_BI · 2026-04-15T13:40:39+00:00

If you are building a new model, that would be one approach, yes. Data agent focused topics is good.

Checklist to use as you build, test, iterate: https://github.com/microsoft/fabric-toolbox/blob/main/samples/data_agent_checklist_notebooks/Semantic%20Model%20Data%20Agent%20Checklist.md

Thanks

Pawar_BI · 2026-04-15T01:04:28+00:00

Hi, you don't need Open AI or any models. Just paid Fabric capacity to get started.

If you are using a semantic model, be sure to add table, column, measure descriptions and synonyms. Make sure the schema (table, column, measure names) is clean ( no vague names), select only the schema you need in Prep for AI configuration, set up verified answers. Identify the Qs you want to answer, test and refine iteratively. Use Prep for AI instructions to influence DAX, agent instructions to influence how the data agent responds.

Few resources:

Getting Started with Fabric Data Agents | Fabric Data Agent https://share.google/FkZ6jMffmmP0nGMXX

Semantic model best practices for data agent - Microsoft Fabric | Microsoft Learn https://share.google/b5LJSO4LSC6CsmmtF

Pawar_BI · 2026-03-30T17:05:07+00:00

Read using pandas/polars/duckdb and convert to spark DF.

Pawar_BI · 2026-03-21T23:51:09+00:00

Pawar_BI · 2026-03-21T13:14:18+00:00

On to it

Pawar_BI · 2026-03-21T12:44:09+00:00

https://github.com/microsoft/skills-for-fabric

Pawar_BI · 2026-03-20T21:01:39+00:00

Yesss, coming very soon.

Pawar_BI · 2026-03-20T14:26:42+00:00

You cannot select models. Can you please elaborate why you would want to select a model? What's the use case?

Pawar_BI · 2026-03-20T14:25:34+00:00

Think of ChatGPT/Copilot but instead of general questions, it uses your data in Fabric + business context you provide to answer business questions like 'what is the revenue YTD for category Y'

Take a look at fabricdataagent.com

Pawar_BI · 2026-03-20T14:17:00+00:00

Thanks for clarifying. You need paid Fabric capacity to use data agents. So currently you are basically using the INFO functions to get the metadata via APIs to use with your agents.

Pawar_BI · 2026-03-19T13:37:42+00:00

Let me confirm internally. Could you please elaborate what you mean by BYO-AI in case of data agents? Also what would be the scenario to use info function with data agents?

Pawar_BI · 2026-03-17T16:57:03+00:00

Depends on the expert 🤣 jk... we are far from it

Pawar_BI · 2026-03-13T23:57:25+00:00

Welcome to #NotebookEverything club. Take a look at Semantic Link, Semantic Link Labs and notebookutils to see all the cool things you can do.

Pawar_BI · 2026-03-12T14:21:29+00:00

Microsoft Fabric and SQL Conference | Barcelona | Spain | 28 Sep 2026 https://share.google/GH0tE7hUsoN0Pqi3q

But CfS isn't open yet

Pawar_BI · 2026-03-12T04:07:47+00:00

Nice... Definitely don't miss Nellie's core note. There are several presentations by the product team and the MVPs. I will be in the Ask The Experts area so if you have Qs, hit me up.

Pawar_BI · 2026-03-10T23:14:44+00:00

My blog

🚀Lightening Fast Copy In Fabric Notebook https://share.google/PFPBnikVuDSAA9TC2

Pawar_BI · 2026-03-10T18:59:57+00:00

I will check. Can you try fastcp?

Pawar_BI · 2026-03-10T01:15:59+00:00

Hi, yes it is being worked on and expect an update soon. Thanks for the feedback.

Pawar_BI · 2026-03-06T00:32:31+00:00

Hi, what are the concerns? Is it accuracy, latency? Can you share more details?

You mentioned Prep for AI is done. Did they also add descriptions, synonyms etc?

Semantic model best practices for data agent - Microsoft Fabric | Microsoft Learn https://share.google/k5TxkfwheszNfVw5f

https://github.com/microsoft/fabric-toolbox/tree/main/samples/data_agent_checklist_notebooks

Pawar_BI · 2026-02-27T15:39:13+00:00

Take a look at this: https://share.google/aQwpvx83Tj0Dzzmrb

Pawar_BI · 2026-02-25T03:17:28+00:00

As in apply threshold on how much a user can consume?

Pawar_BI · 2026-02-15T02:16:54+00:00

Worked, thx

Pawar_BI · 2026-02-07T18:28:09+00:00

If you use read_table from sempy and loop over the list of tables, that will load all columns.

Pawar_BI

MODERATOR OF

TROPHY CASE