The Data Massagist The Data Massagist by Pablo Junco

Filter by

29 Articles match the selected category: MS Fabric


Agent-of-Agents: Why AI Future Is Recursive

Agent-of-Agents: Why AI Future Is Recursive

This edition of The Data Massagist explores the rise of agent ecosystems as the next evolution of enterprise AI. Instead of isolated copilots or chatbots, organizations are moving toward Multi-Agent Systems (MAS) where specialized AI agents collaborate, delegate tasks, and consume the outputs of other agents to execute end-to-end workflows. The article explains why this shift is happening now and how enterprises are adopting coordinated intelligence patterns such as triage (intake and prioritization), routing (dynamic task delegation), and orchestration (workflow execution and control). It highlights how industries like telecom, healthcare, manufacturing, and energy are already applying these models, and why the future of AI will depend on building scalable, governed ecosystems of interacting agents rather than standalone tools.

Read it on LinkedIn

Data Agents Databricks MS Fabric MS Foundry Newsletter

Understanding AI Costs in Microsoft Fabric & Monitoring Usage

Understanding AI Costs in Microsoft Fabric & Monitoring Usage

Microsoft Fabric uses a unified, token-based AI billing model where all AI features — including Copilot for Power BI, Copilots in Fabric, Data Agents, and Operational Agents — consume Capacity Units (CUs) from the organization’s Fabric capacity. Instead of separate AI licenses or per-prompt fees, costs are calculated based on input and output tokens, with output tokens typically driving higher consumption. The article explains how AI workloads are monitored through the Fabric Capacity Metrics App, Admin Portal, and Activity Logs, giving organizations visibility into token usage, CU consumption, and workload spikes. It also clarifies licensing considerations for Power BI Copilot and highlights the difference between Data Agents (AI that answers) and Operational Agents (AI that acts autonomously). Ultimately, the model provides predictable, transparent, and centralized AI cost management within Microsoft Fabric.

Read it Now

Data Agents MS Fabric

Your Data Estate Is Slowing Down AI — Fix It!

Your Data Estate Is Slowing Down AI — Fix It!

This edition of The Data Massagist explores two critical forces shaping enterprise AI readiness: governance and data modernization. First, it clarifies how Microsoft Fabric and Microsoft Purview complement each other, highlighting that Fabric includes strong built-in governance capabilities such as OneLake cataloging, lineage, security, and policy enforcement—making it sufficient for many scenarios without requiring Purview. However, as organizations scale across hybrid and multi-cloud environments, Purview becomes essential to extend governance across the entire data estate. Second, it addresses the growing reality that legacy data platforms are becoming a bottleneck for AI adoption. With most AI initiatives dependent on AI-ready data, modernizing databases is now a strategic requirement rather than an IT upgrade. The edition outlines how modern cloud databases support vector search, semantic querying, and AI-native capabilities, and why Azure provides a comprehensive foundation for this transformation. The core message: AI success depends less on models and more on modern, well-governed, and AI-ready data foundations.

Read it Now

MS Fabric MS Purview Newsletter

Scaling Databases Is Easy. Architecture at 100TB Is Not.

Scaling Databases Is Easy. Architecture at 100TB Is Not.

Modern data architecture is shifting from isolated systems to converging platforms. While every cloud provider can scale beyond 100TB, the real differentiation is how organizations achieve that scale—without redesigning applications, adding complexity, or creating technical debt. Enterprise architectures typically fall into three models: operational scale (single-database abstraction like Azure SQL Hyperscale), distributed scale (Cosmos DB-style partitioned systems), and analytics/AI platforms (Microsoft Fabric, ADLS, Synapse), which are not transactional databases but data platforms for intelligence at petabyte scale. Microsoft is increasingly unifying these layers through Fabric’s emerging database capabilities, while the industry is converging in parallel, with players like Databricks extending into operational workloads via Lakebase. The core shift: boundaries between operational, distributed, and analytics systems are disappearing, and architecture—not scale alone—now defines business success.

Read it Now

MS Fabric MS SQL

Governing AI Responsibly in Modern Analytics Platforms

Governing AI Responsibly in Modern Analytics Platforms

AI adoption is accelerating—projected to reach 1.3B agents by 2028—making siloed approaches ineffective. Chief Data Officers (CDOs) are key to enabling responsible, scalable AI built on modern platforms like Microsoft Fabric, Snowflake, and Databricks, which now serve as both data and AI foundations. While Snowflake and Databricks offer flexibility, they require strong governance; Fabric emphasizes built-in control and compliance. As AI agents grow more autonomous, CDOs must expand from data governance to full AI governance, including models, prompts, and actions. Microsoft Purview emerges as a unified, cross-platform governance layer, enabling visibility, control, and risk management. Ultimately, responsible AI depends on architecture and governance by design—not just principles.

Read it Now

Data Governance Databricks MS Fabric MS Purview Newsletter Responsable AI Snowflake

PBI Dataflows Gen1 Is Over. What Comes Next?

PBI Dataflows Gen1 Is Over. What Comes Next?

Power BI Dataflows Gen1 is entering a legacy, maintenance-only phase, signaling a broader architectural shift rather than a simple product update. Gen1 was designed for a BI‑centric, self‑service era, optimized for report preparation with limited reuse, governance, and scalability. As data platforms evolve to support multiple personas, AI, and shared data assets, these design constraints become structural limitations. Microsoft Fabric and Dataflows Gen2 introduce a different model: centralized transformations, OneLake‑based storage, and reuse across analytics, engineering, and AI workloads. Gen2 is not a drop‑in replacement but part of a unified, Fabric‑native architecture. Migration should therefore be treated as a strategic modernization effort, not a lift‑and‑shift exercise, to improve reuse, governance, performance, and AI readiness.

Read it Now

Migration MS Fabric Power BI

Building a Fabric Data Agent with On‑Premises SQL Server Data

Building a Fabric Data Agent with On‑Premises SQL Server Data

Organizations can keep on-premises SQL Server systems while enabling modern AI by using Microsoft Fabric. Data is continuously mirrored into OneLake, avoiding complex ETL and enabling real-time analytics without disrupting operations. A key requirement is building a strong semantic layer that defines business meaning, ensuring accurate, governed AI insights. Fabric Data Agents then provide natural-language access to this curated data via tools like Copilot. This architecture separates operational and analytical workloads, improves scalability, and enforces governance. The result: faster insights, reduced maintenance, and trusted AI-driven analytics—while preserving existing systems and modernizing incrementally.

Read it Now

Data Agents MS Fabric MS SQL

From SAP Modernization to AI‑Frontier Firms

From SAP Modernization to AI‑Frontier Firms

The Microsoft–SAP alliance goes beyond infrastructure modernization — it enables full business reinvention. By combining SAP’s mission-critical systems with Microsoft Azure and Microsoft Fabric, organizations can securely migrate workloads while unlocking the value of their data. Microsoft Fabric provides a unified data platform that connects SAP and non-SAP data into a single, governed foundation (OneLake), enabling real-time analytics, AI, and intelligent automation. This allows enterprises to move beyond “lift-and-shift” toward a three-step journey: migrate, unify, and transform with AI. The real value comes from activating AI on top of unified data — empowering human-agent collaboration, faster decision-making, and scalable innovation. Organizations that embrace this approach evolve into AI-Frontier Firms: data-driven, AI-powered enterprises that continuously reinvent how they operate, compete, and deliver value.

Read it Now

MS Fabric SAP

100+ Articles, One Hub and, FabCon Recap

100+ Articles, One Hub and, FabCon Recap

Edition #8 of The Data Massagist marks two milestones: the launch of thedatamassagist.com and key takeaways from FabCon / SQLCon Atlanta 2026. The new website centralizes 100+ articles from LinkedIn, Forbes, and other platforms into a curated, category-driven experience with AI-generated summaries—built as a hands-on coding project with the author’s 11-year-old son. FabCon/SQLCon highlighted a strategic shift toward convergence: Microsoft Fabric as the data and AI control plane, Azure Databricks as a complementary execution engine, Purview as the governance backbone, and SQL as a modern, AI-ready foundation. The core message: fewer platforms, stronger integration, and architecture focused on outcomes, trust, and intelligence.

Read it Now

Databricks MS Fabric MS SQL Newsletter

Designing AI‑Ready Analytics with Microsoft Fabric Data Agents

Designing AI‑Ready Analytics with Microsoft Fabric Data Agents

As organizations adopt AI-driven analytics, exposing trusted data to Copilot and Fabric Data Agents requires strong architecture—not just enablement. Microsoft Fabric Data Agents add conversational analytics over governed data, but report-embedded semantic models create fragile AI behavior, unclear cost ownership, and governance risk—especially as customers migrate from Power BI Premium to Fabric capacities. Through two Contoso case studies, the article shows why extracting reusable, standalone semantic models is essential for AI readiness. By combining governed semantic models with Fabric Mirroring for Oracle, organizations achieve predictable AI costs, stable and explainable AI responses, centralized security (RLS/OLS), and scalable foundations for Data Agents and future Copilot experiences. The key takeaway: AI succeeds when semantics are treated as first-class data products.

Read it Now

Data Agents MS Fabric Power BI

Planning in Fabric IQ, why it matters now

Planning in Fabric IQ, why it matters now

Fabric IQ brings enterprise planning and forecasting directly into the Fabric platform, eliminating the traditional separation between analytics and planning tools. Budgets, forecasts, targets, and scenarios now sit on top of governed Fabric data, shared semantic models, and OneLake, using open formats like Delta and Iceberg. This is especially transformative for agentic AI: by unifying actuals, plans, and scenarios in a single semantic layer, AI can reason about intent and future outcomes, not just historical data. The result is a move from passive reporting to AI‑driven decision intelligence.

Read it Now

MS Fabric

The Economics of Modern Data Platforms

The Economics of Modern Data Platforms

This is Edition #7 of the newsletter, focused on how pricing really works in modern data platforms like Microsoft Fabric and Azure Databricks. It explains how compute consumption (CUs vs DBUs) is the main cost driver and why architecture—not pricing tables—ultimately determines spend. The article explores the impact of storage, data movement, and query behavior on total cost, highlighting hidden inefficiencies. It also compares both platforms’ approaches to scalability and performance. Finally, it provides practical strategies for cost optimization through better design, observability, and FinOps discipline.

Read it Now

Databricks MS Fabric Newsletter

Why It’s Time to Move from Power BI Real-Time Streaming to Fabric RTI

Why It’s Time to Move from Power BI Real-Time Streaming to Fabric RTI

In this article, Pablo addresses a common question following his piece on Fabric Real-Time Intelligence (RTI): whether organizations should migrate Power BI real-time streaming solutions to Fabric RTI, Azure Databricks, or Tableau. He argues this is not a simple product swap but a fundamental architectural shift. Power BI streaming was designed for lightweight, ephemeral visualization of live signals, while Fabric RTI is a full real‑time analytics platform built for persistence, governance, automation, and AI-driven decisions. With Power BI streaming entering sunset and retirement planned for 2027, RTI represents Microsoft’s strategic future—unifying event ingestion, storage, analytics, and actionability. Pablo explains why migration should be incremental, what new capabilities RTI unlocks, and why alternatives like Databricks or Tableau often miss the mark. The real shift is from real‑time dashboards to real‑time intelligence.

Read it Now

Migration MS Fabric Power BI

Why Data Platform Migration is a Business Strategy, not an IT Project

Why Data Platform Migration is a Business Strategy, not an IT Project

Most enterprises don’t modernize from a blank slate—they migrate decades of legacy systems. This article explains why data platform migration is a business transformation, not an IT upgrade, and why success depends on disciplined execution. It presents a proven six‑phase, wave‑based migration approach that delivers complete, consumable data products by business domain, reducing risk while accelerating value. With real‑world examples and Microsoft tooling support, the message is clear: done right, migration becomes a catalyst for agility, AI innovation, and enterprise‑wide modernization.

Read it Now

MS Fabric Newsletter

From Blank Canvas to Data Architecture: Designing Greenfield Platforms

From Blank Canvas to Data Architecture: Designing Greenfield Platforms

This article explores greenfield data architecture as a rare opportunity to design the future without legacy constraints. Using art as a metaphor, it explains why greenfield platforms demand clarity, responsibility, and strong design principles from day one. It shows how modern architectures converge on lakehouse‑first foundations, open data formats, and built‑in governance, and compares three proven paths: Azure Databricks with Power BI, Microsoft Fabric, or both together. The conclusion is clear: greenfield success is not about tools or speed, but about building an architecture that can evolve, scale, and endure over time.

Read it Now

Databricks MS Fabric Newsletter

Why Organizations wants Fabric IQ?

Why Organizations wants Fabric IQ?

Microsoft Fabric IQ is gaining strong interest because it solves a long‑standing enterprise AI problem: the lack of shared business meaning. Instead of adding more dashboards or models, Fabric IQ introduces a governed ontology that defines business concepts, relationships, and rules across data, analytics, and AI. When combined with Foundry IQ, it enables AI agents to reason with real business context, explain outcomes, and recommend actions—making enterprise AI practical, scalable, and operationally relevant for the first time.

Read it Now

MS Fabric

Practical Architecture for Graph-Driven Insights in Data Agents

Practical Architecture for Graph-Driven Insights in Data Agents

In the fourth edition of The Data Massagist, Pablo Junco Boquer answers a common customer question: how to add graphs to responses generated by Fabric Data Agents in Microsoft Fabric. He clarifies the role of Fabric Data Agents as governed, read‑only reasoning engines designed for trusted, conversational analytics—and contrasts them with Operations Agents, which monitor real‑time signals and can trigger actions to protect business operations. While Data Agents cannot render visualizations directly, Pablo introduces three practical architectural patterns to combine them with graph‑based insights: pairing Data Agents with Power BI semantic models, leveraging Graph in Microsoft Fabric for relationship analytics, and orchestrating Data Agents with Microsoft Foundry to dynamically generate graphs. Together, these patterns show how Fabric is evolving from a data platform into a full intelligence platform—where reasoning, governance, and visualization work together.

Read it Now

MS Fabric MS Foundry Newsletter

Modern Data Platforms Aren’t About Data

Modern Data Platforms Aren’t About Data

In this edition of The Data Massagist, I reflect on recent milestones—from presenting at the Microsoft AI Tour to earning Fabric and Databricks certifications—and use them to explore a deeper truth: data platforms succeed not because of tools alone, but because of structure and clarity. I introduce the seven business layers of a real data platform, showing how Microsoft Fabric simplifies each one—from raw signals to intelligent experiences—while reducing complexity, TCO, and organizational blind spots. Ultimately, great platforms don’t create advantage; clear, shared understanding does.

Read it Now

Databricks MS Fabric Newsletter

The Real Magic Behind AI Accuracy Isn’t AI — It’s Your Data

The Real Magic Behind AI Accuracy Isn’t AI — It’s Your Data

In the second edition of The Data Massagist, Pablo Junco Boquer explores what truly powers Agentic AI solutions such as Microsoft Copilot, Copilot for Power BI, and Fabric Data Agents. While AI adoption and ROI are accelerating, Pablo argues that real AI accuracy does not come from better prompts or newer models—it comes from better data foundations. AI failures, he explains, are data problems, not model problems. The “real magic” happens in preparation: trusted, well‑modeled, and governed data expressed through strong semantic models. Using Microsoft Fabric, organizations can turn raw data into AI‑ready knowledge by aligning business meaning, storage modes, and governance. Semantic models become the shared language between humans and AI, enabling agents to reason accurately, scale understanding, and deliver reliable business outcomes without confident mistakes.

Read it Now

Data Agents MS Fabric MS Purview Newsletter

Driving RTI Adoption with Eventhouse Connectors

Driving RTI Adoption with Eventhouse Connectors

Most organizations struggle with real‑time analytics not because of dashboards, but because data arrives too late to drive action. This article explains how Eventhouse connectors in Microsoft Fabric help teams accelerate time‑to‑insight without rebuilding pipelines or writing extensive code. Ingestion is treated as a core architectural decision, directly impacting speed, flexibility, and scalability. Fabric RTI integrates natively with Azure services and popular open‑source tools, streaming data into Eventhouse KQL databases in seconds. When connected to OneLake, this data becomes instantly usable across BI, analytics, AI, and automation with unified governance. Low‑code and no‑code ingestion patterns reduce complexity, enabling organizations to turn existing signals into real‑time intelligence—and a sustained competitive advantage.

Read it Now

MS Fabric

Microsoft Fabric RTI: From Dashboards to Decisions

Microsoft Fabric RTI: From Dashboards to Decisions

As data platforms evolve, organizations are drowning in telemetry but still struggle to turn real‑time signals into confident operational decisions. This piece explains why Microsoft Fabric Real‑Time Intelligence (RTI)—recognized as a Leader in the 2025 Forrester Streaming Data Wave—represents a shift from observability to operability. It shows how RTI closes the loop between live data, anomaly detection, and action through real‑time dashboards, behavioral AI‑driven detection, and an Operations Agent that guides responses. The result is faster insight, fewer false alarms, lower operational risk, and a practical path to running systems—not just monitoring them—in real time.

Read it Now

MS Fabric

Uniting SAP Data and Azure Analytics to Power Enterprise AI

Uniting SAP Data and Azure Analytics to Power Enterprise AI

Microsoft Ignite 2025 marked a major shift in enterprise data strategy with the introduction of SAP Business Data Cloud (BDC) Connect for Microsoft Fabric. This new capability enables bi‑directional, zero‑copy data sharing between SAP BDC and Microsoft Fabric’s OneLake, unifying SAP and non‑SAP data for analytics and AI without duplication. Combined with Delta Sharing support for Azure Databricks, organizations can preserve existing investments while gaining a governed, AI‑ready data foundation. The result is faster insights, simplified architectures, and scalable AI innovation. By embracing open formats, interoperability, and strong governance, SAP and Microsoft are enabling enterprises to move beyond silos and turn operational data into actionable intelligence.

Read it Now

MS Fabric SAP

Microsoft Fabric: Redefining the Future of Enterprise Data Intelligence Platforms

Microsoft Fabric: Redefining the Future of Enterprise Data Intelligence Platforms

Microsoft Fabric is rapidly redefining enterprise data intelligence through a unified, AI‑native platform highlighted at FabCon Europe 2025. At its core is OneLake, an open, multi‑cloud data foundation enabling zero‑copy access via shortcuts, mirroring, and new Table APIs built on open standards like Delta and Iceberg. Real‑Time Intelligence (RTI) is the fastest‑growing Fabric workload, powering planet‑scale streaming, Digital Twin Builder, and event‑driven analytics. New capabilities such as Fabric MCP, Graph, Maps, and Anomaly Detection extend Fabric into AI‑assisted development and operational intelligence. Combined with major performance and pricing gains, Fabric delivers scalable, governed analytics with exceptional value—making it a strategic platform for AI‑driven enterprises.

Read it Now

MS Fabric MS Foundry Snowflake

Why Azure Databricks Is a Top Priority for Microsoft

Why Azure Databricks Is a Top Priority for Microsoft

Azure Databricks is a first‑party service in Microsoft’s analytics portfolio and a strategic priority, not a competitor to Microsoft Fabric. Customers can choose Fabric, Databricks, or both—without internal Microsoft bias—because sellers are aligned to recommend the best fit. Azure provides the best-performing cloud for Databricks, with proven performance gains, tight security, and deep integration with Microsoft’s ecosystem. Native interoperability with Fabric, Power BI, Azure AI Foundry, Purview, and the Power Platform enables unified, governed lakehouse architectures without data duplication. Together, Microsoft and Databricks deliver an open, scalable, and AI‑ready data platform trusted by enterprises worldwide.

Read it Now

Databricks MS Fabric MS Foundry SAP

Decoding the Snowflake and Microsoft Partnership

Decoding the Snowflake and Microsoft Partnership

The Microsoft–Snowflake partnership enables enterprises to unify data without duplication using open standards like Apache Iceberg. By combining Snowflake’s compute with Microsoft Fabric, OneLake, and Azure AI, organizations reduce complexity and accelerate analytics and AI—without heavy integrations.

Read it Now

MS Fabric Snowflake

Unlocking Business Agility with Multi-Agent AI and Microsoft Fabric’s Data Mirroring

Unlocking Business Agility with Multi-Agent AI and Microsoft Fabric’s Data Mirroring

This article explains why Multi‑Agent AI is a major shift for enterprise decision‑making and how Microsoft Fabric strengthens Microsoft’s agentic AI strategy. Multi‑agent systems combine specialized AI agents to analyze diverse internal and external data sources, accelerating decisions, scaling intelligence, and reducing manual work. Microsoft Fabric enables this through Data Mirroring, which keeps enterprise data synchronized in near real time without ETL or duplication, and Data Agents, which go far beyond chatbots by generating queries, insights, and visualizations from multiple data sources using natural language. Integrated with Azure AI Foundry, Fabric grounds multi‑agent workflows in trusted enterprise data, lowering cost and complexity while delivering faster, smarter business outcomes.

Read it Now

MS Fabric MS Foundry Oracle

Why Business Leaders Should Care About MCP and A2A?

Why Business Leaders Should Care About MCP and A2A?

AI agents are rapidly evolving into intelligent collaborators capable of orchestrating complex workflows across enterprise systems. Two emerging standards—Model Context Protocol (MCP) and Agent‑to‑Agent (A2A)—are at the center of this shift, enabling interoperability, tool discovery, and scalable multi‑agent coordination. MCP standardizes how agents access tools and data, while A2A allows independent agents to collaborate across organizations and platforms. Microsoft is investing heavily in both protocols across Azure AI Foundry, Fabric, Copilot Studio, and Azure OpenAI, combining open standards with enterprise‑grade security and governance. With strong ROI signals and industry adoption accelerating, MCP and A2A are laying the foundation for agentic AI to deliver real, cross‑industry business impact.

Read it Now

MS Fabric MS Foundry

Shortcuts and Mirroring at Microsoft Fabric

Shortcuts and Mirroring at Microsoft Fabric

This article introduces Microsoft Fabric as a unified analytics platform built around OneLake, an open, governed SaaS data lake designed to centralize enterprise data and simplify analytics and AI. It highlights two key capabilities: OneLake Shortcuts, which virtualize data across clouds and systems without duplication, and Fabric Mirroring, which enables near–real‑time replication from external databases into OneLake without complex ETL. Together, these features break down data silos, reduce latency, and accelerate insights while maintaining open formats like Delta Parquet. With seamless integration into Azure AI and Azure Databricks, Microsoft Fabric delivers a flexible, scalable foundation for modern analytics, BI, and AI‑driven decision‑making.

Read it Now

MS Fabric SAP

Evolving Big Data Strategies With Data Lakehouses And Data Mesh

Evolving Big Data Strategies With Data Lakehouses And Data Mesh

This piece revisits a Forbes article published in August 2023, where Pablo Junco argued that Chief Data Officers should modernize big data strategies by adopting Data Lakehouse and Data Mesh architectures. Ten months later, those recommendations remain highly relevant, reinforced by Microsoft’s announcement of Microsoft Fabric. The article highlights the importance of reducing duplicated data, avoiding costly and unreliable ETL pipelines, and enabling real‑time analysis on operational data. It positions the lakehouse as a unified foundation for analytics and machine learning, while data mesh promotes data democratization across business units. Together with strong governance and modern analytics, these approaches help organizations lower costs, accelerate innovation, and build a sustainable, data‑driven culture.

Read it on Forbes.com

Databricks Forbes MS Fabric

Article summary by M365 Copilot


Let’s talk!
Let's have cafecito together.

If you’re a Chief Data Officer (CDO), a data leader, or simply someone who believes in the power of preparing data for AI—you’re already a Data Massagist.

Whether you have an idea, a challenge, or just want a fresh perspective, let’s connect. I’m always open to collaborating, learning, and helping others move forward.

You can find me on LinkedIn (feel free to connect and send me a message), or book time with me directly for a virtual coffee (or "cafecito").