Fabric Data Agent Accuracy Is a Distribution, Not a Number
I asked a Fabric data agent 24 questions in three wordings, ten times each, on real AEMO data. It scored 82%, but only 39% of wordings were always right.
119 articles
I asked a Fabric data agent 24 questions in three wordings, ten times each, on real AEMO data. It scored 82%, but only 39% of wordings were always right.
Fabric data agents now use GPT-5.1 and a Responses API client. What notebook, Foundry and app callers must change, and why you need a full eval re-run.
The Agent Framework Harness bundles planning, memory, compaction, approvals and telemetry. When to accept its opinions and when a plain Agent is better.
Decide what an agent does when a tool fails, a step runs out of budget or grounding is weak before launch, and make the release check fail without it.
Structured outputs fix the shape of a model's answer, not its meaning: a two-layer contract between a Foundry model and the systems that consume it.
Typed state and checkpoints don't stop an agent paying twice: five places agent workflow state breaks at its boundaries, and patterns that hold.
Good retrieval is wasted if users cannot verify the answer, so design RAG citations to be checkable, validated in code and measured like relevance.
How I sample real user queries by stratum, redact PII before anyone reads them, split off a holdout and keep the eval set current as the product changes.
An offline evaluation can't tell you how a new model handles real traffic. How I'd canary a Foundry model change with sticky splits and per-call version logs.
Hybrid search is default RAG advice, but the BM25 leg has real costs; a three-way test on Azure AI Search shows which questions it rescues.
A tool policy nobody tests is a comment. How to assert agent tool lists and approvals in CI, then gate tool use on a golden set of scenarios.
Make retrieval-first a team rule: an owned question set, a side-by-side index comparison on Azure AI Search, and a gate that fails on lost answers.
Every Foundry model deployment has a version upgrade policy, and the default swaps your model at retirement. How to choose, audit and run model changes safely.
Agents get confused when workflow state lives in the chat transcript. Four patterns for typed state, fresh context and code-owned transitions.
The semantic ranker only reorders the top 50 results. A with-and-without test on a labelled set shows which RAG queries it rescues and which it just slows.
Agent reliability depends on which tools a model can reach. Four layers of tool policy (surface, schema, approval, budget) with Agent Framework code.
Most wrong RAG answers start with the passages, not the prompt. A labelled question set and a retrieval-only triage on Azure AI Search show which one to fix.
Most agent designs only need autonomy in one step. How to build the workflow around it with Agent Framework executors, switch-case edges and loop caps.
Azure AI Search knowledge bases now plan queries for you, in preview. When to hand over the RAG pipeline, when to keep building it, and how to test both.
Why I now prefer explicit, predictable code over clever one-liners, the four questions I ask before merging, and when terse code is the better choice.
Diagnose why a RAG system fails before adding patterns: hybrid search, semantic reranking, grounding gates and citations on Azure AI Search, mapped to failures.
This foundation can be extended with calendar integration, email access, and more plugins. Perfect for a holiday coding project!
Many teams that started with LangChain in 2024 are now evaluating Semantic Kernel for its tighter Azure integration and production-ready features. Having…
LLM outputs vary between runs and model versions. Testing must focus on behavioral properties rather than exact string matching, while still catching…
Configure appropriate timeout settings for AI operations and implement retry logic for transient failures. Consider using premium plans for…
Table extraction transforms static reports into queryable data. Combine extracted tables with LLM analysis to answer questions about financial statements…
First, provision an Azure AI Document Intelligence resource and configure your client. The prebuilt invoice model recognizes vendor details, line items…
JSON mode guarantees the model outputs valid JSON, though you still need to specify the schema in your prompt.
Functions are defined as JSON schemas that describe parameters and their types. Well-designed function schemas and clear descriptions ensure the model calls…
Automated pipelines ensure reproducibility, enable A/B testing, and provide audit trails for model governance.
RAG works by first retrieving relevant documents from a search index, then passing those documents as context to an LLM for generation. This approach…
Monitor reranker scores and caption extraction quality. A/B test semantic ranking against pure vector or keyword search to quantify improvements for your…
Multimodal RAG ensures users find relevant information regardless of how it's represented in the source documents.
Structured outputs eliminate parsing errors. Add business validation for semantic correctness - the schema ensures format, you ensure meaning.
Use Redis Vector Search for efficient similarity matching at scale. Tune the similarity threshold based on your use case - higher values ensure more precise…
Graph RAG significantly improves answers for questions involving relationships, hierarchies, and multi-hop reasoning.
Use consumption-based billing to pay only for actual inference time. Implement caching for repeated queries and batch similar requests to amortize cold…
Enable extended thinking for mathematical proofs, code analysis, strategic planning, and multi-constraint optimization problems. For simple queries…
Configure Azure Monitor alerts on latency and error rates. Implement automatic rollback triggers when thresholds are breached.
Guardrails are essential for enterprise AI deployments, protecting both users and your organization.
After training completes, evaluate on a held-out test set before deploying. Monitor the fine-tuned model's performance against the base model to ensure…
Fail builds when quality metrics drop below thresholds, catching regressions before they reach production.
Azure AI Foundry provides trace visualization showing the complete agent interaction graph, making it easy to debug complex workflows and optimize handoff…
Track cache hit rates in your monitoring. Applications with high context reuse typically see 60-80% cache hit rates, dramatically reducing per-request costs.
Configure your Cosmos account with write regions near your users and read replicas globally. Vector searches automatically route to the nearest replica…
Use spot instances for non-critical workloads, implement request batching for throughput optimization, and configure appropriate scale-to-zero policies.…
Vector search costs can spiral quickly at scale. After optimizing Azure AI Search deployments processing 50 million vectors, I've identified key patterns…
For multi-page documents, process pages in parallel and use a synthesis step to merge extracted data. GPT-4o handles cross-page references like "continued…
Claude 3.5 Sonnet has become my go-to model for automated code review workflows. Its exceptional ability to understand context across large codebases makes…
The new agent framework introduces several critical improvements. First, native multi-agent orchestration allows agents to collaborate without custom…
A batch pipeline for call and meeting audio: Azure AI Speech transcription with diarization, then GPT-4o structured outputs into rows you can query.
Draft column descriptions for an Azure SQL database with Azure OpenAI, grounded in profiling stats, reviewed by a data owner, then stored as MS_Description.
Use Azure OpenAI structured outputs to draft edge-case test data for PySpark transforms, review it like code, and let pytest and assertDataFrameEqual decide.
Use Azure OpenAI structured outputs to draft Great Expectations rules from a data profile, then backtest and review them before they ever gate a pipeline.
A practical first project in Azure AI Foundry for data teams: hubs and projects, the preview azure-ai-projects SDK, and an evaluation loop from day one.
A practitioner's read on Anthropic's Model Context Protocol in January 2025: the primitives, a read-only SQL server in Python, and when not to use it.
Robust error handling is what separates prototypes from production systems. Invest in comprehensive error handling early to avoid painful debugging later.
Reliable extraction requires careful schema design, multi-pass validation, and explicit handling of uncertainty. These patterns help you build extraction…
Type safety transforms AI applications from fragile prototypes into robust production systems. Invest in types early - your future self will thank you.
Pydantic integration makes OpenAI's structured outputs truly type-safe, catching errors at development time and ensuring your AI-generated data is always valid.
Route based on multiple state attributes: Sometimes you don't know all routes ahead of time: Multiple decision points in sequence: Route with randomization…
LangGraph provides these capabilities through a graph-based execution model.
LangChain 0.2.x Stability LCEL (LangChain Expression Language) Maturity Azure AI Search Vector Store
The Microsoft Fabric SDK provides a Pythonic interface for working with Fabric services. This guide covers installation, configuration, and common…
Which Azure AI Search index changes work in place, which force a rebuild, and how to swap versioned indexes, load documents and check health safely.
How to design semantic configurations, use reranker scores as a RAG cut-off, and decide when Azure AI Search's semantic ranker is worth paying for.
A practical look at CrewAI 0.1.x with Azure OpenAI: how agents, tasks and sequential crews work, what's missing today, and when to choose it.
A practical look at AutoGen 0.2 with Azure OpenAI: wiring the config, stopping runaway conversations, sandboxing generated code and registering tools.
How to add retrieval grading, query rewriting, and groundedness checks to RAG on Azure OpenAI and Azure AI Search without tripling latency or cost.
Chunk documents along their headings, keep tables whole and prefix every chunk with its section path, using Document Intelligence markdown output and Python.
How to structure a production AI assistant on Azure OpenAI Chat Completions: conversation state, retrieval, tool calling and the orchestration loop you own.
How to drive OpenAI Assistants API runs reliably in January 2024: the run state machine, polling, function calls, expiry, concurrency and cost.
GPT-4 Turbo is still a preview model on Azure OpenAI; here's how I'd deploy, budget, retry and test around 1106-preview before real users touch it.
Code Interpreter (Advanced Data Analysis) is the single most productive AI tool I've used for exploratory analysis — it runs Python in a sandbox, opens…
Deep dive into LangChain's Runnable interface and its implementations for building flexible LLM pipelines.
Understanding LangChain Expression Language for building composable LLM applications with clean, declarative syntax.
Deep dive into the SemPy library for working with Power BI semantic models in Microsoft Fabric notebooks.
Building end-to-end data science workflows using Microsoft Fabric's integrated capabilities.
Learn how to use LangChain with Azure OpenAI Service to build robust, production-ready AI applications.
LangChain's velocity in 2023 has been remarkable and occasionally destabilising — the 0.0.x series has introduced breaking API changes in point releases…
Tomorrow we'll explore Hugging Face integration with Azure. PEFT Documentation PEFT GitHub TRL Library
AI agents represent the next evolution of AI systems. By combining planning, tool use, and memory, they can autonomously accomplish complex goals while…
AI orchestration patterns enable building sophisticated AI systems from modular components. The key is designing for reliability, observability, and…
AI-powered data quality goes beyond static rules. Intelligent systems understand context, detect subtle anomalies, and provide actionable recommendations…
Spark ML provides battle-tested patterns for production machine learning. From feature engineering to model persistence, these patterns ensure reliable ML…
Error: {type(error).name}: {str(error)} response = openai.ChatCompletion.create( engine="gpt-4", messages=[{"role": "user", "content": prompt}] ) return…
AI data analysis assistants make insights accessible to everyone, regardless of technical expertise. The key is combining natural language understanding…
Combined with Azure OpenAI's enterprise security and compliance, it's a powerful combination.
Create reusable, parameterized prompts: Combine components into workflows: Load content from various sources: Split documents for embedding: Generate…
This cycle is repeated for each new piece of functionality. The result is a suite of tests that provide confidence in the code and make it easier to…
What retrieval augmented generation is, why it beats fine-tuning for company knowledge, and a minimal loop on Azure OpenAI completions in January 2023.
Run Qdrant 0.11 with Azure OpenAI embeddings: valid point IDs, payload indexes, filtered HNSW search, memory settings, and when Qdrant isn't the right choice.
Run Milvus 2.2 standalone, load Azure OpenAI embeddings with pymilvus, and learn the schema, index, consistency and delete rules before you self-host it.
Run Weaviate 1.17 with embeddings from Azure OpenAI: schema choices, batch imports, filtered vector search, BM25 and the hybrid search caveats to know first.
Set up a Pinecone index for Azure OpenAI embeddings: dimensions, pod types, namespaces, metadata indexing and idempotent upserts, plus when to skip it.
Build a small semantic search prototype on Azure OpenAI embeddings and NumPy, measure it with hit rate@k, add BM25, and know when to move to a real index.
What text embeddings are, which Azure OpenAI embeddings models you can use in January 2023, how to compare vectors, and when embeddings are the wrong tool.
How stream=True works on the Azure OpenAI 2022-12-01 Completions API, what you give up by streaming, and how to relay tokens to a browser without losing any.
What the GA 2022-12-01 Azure OpenAI REST API looks like on the wire: URLs, auth headers, completions, embeddings, errors and when to skip the SDK.
Azure OpenAI Service reached GA on 16 January 2023: what that changes for production plans, what still needs an approved application, and how to proceed.
How to configure the openai 0.26 Python library for Azure OpenAI in January 2023: API keys or Azure AD tokens, deployment names, timeouts, retries and async.
Azure OpenAI is GA with a Completions API only, and ChatGPT is coming soon. How to decide what needs chat and keep your prompt code ready for the change.
How temperature and top_p reshape token sampling in Azure OpenAI completions, why to tune one not both, and how to measure the effect before you ship.
Azure OpenAI completion models have no system role yet. How to design, budget, version and test an instruction preamble that does that job instead.
How to pick, order and budget few-shot examples for Azure OpenAI completion models, with the biases to watch for and when to stop adding examples.
How to count tokens with tiktoken, size max_tokens, log real usage and cap spend for Azure OpenAI completion models in the January 2023 preview.
Azure OpenAI preview limits are requests per second per deployment. How to pace calls, retry 429s properly and scale out with the openai 0.26 Python library.
How Azure OpenAI's preview content filter shows up in code: HTTP 400 prompts, content_filter finish reasons, and why you still need your own guardrails.
Azure OpenAI's preview ships with use-case review, content filtering and abuse monitoring. Here is where those controls stop and your application's begin.
Azure OpenAI or OpenAI's own API in January 2023? Access, models, data use, cost and code compared, plus one Python client that can target either.
There is no ChatGPT API yet. Here is how to build multi-turn chat on Azure OpenAI's Completions API: transcripts, state, token budgets and streaming.
What GPT-3.5 means on Azure OpenAI in January 2023: which models are in the catalogue, what they cost, and how to design for text-davinci-003's arrival.
How GitHub secret scanning works in early 2022, what it misses, and a practical playbook for triaging alerts, custom patterns, and rotating leaked keys.
The Databricks REST API exposes every workspace capability that the UI and CLI provide—and then some—making it the integration point for external…
In the past, I've been using my Macbook Pro to do all things blockchain and smart contracts development. One of the hurdles I encountered in the past is…
1. Define schemas explicitly Never rely on schema inference in production 2. Use built in functions Avoid UDFs when possible 3. Write pure transformation…
Which Azure Advisor cost recommendations are safe to act on, which need judgement, and how to pull, tune and suppress them with the CLI and Python SDK.
How to put Form Recognizer's preview invoice model behind confidence thresholds, business-rule checks and a human review queue before data reaches the ERP.
.NET on Functions is the default story Microsoft tells, but in practice the serverless workload that lands on my desk most often is a Python data scientist…