Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Madhu_Bhowal

Unlocking financial insights with Capital Markets DataHub workload—A partner-led innovation in Microsoft Fabric (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 


We are releasing the preview of a domain‑native data solution built as a workload in Fabric to power analytics and AI-enabled use-cases for capital markets and hedge fund customers in the finance industry. Financial institutions are moving fast to modernize their analytics stack and accelerate AI adoption, however in capital markets, data complexity remains the single biggest blocker to achieving that goal.

Disparate source systems, inconsistent identifiers, manual reconciliation, and strict regulatory requirements make it difficult to create trusted data assets, let alone safely expose them to AI. This is exactly the problem Capital Markets Datahub on Microsoft Fabric is designed to solve.

The Capital Markets Datahub workload is a third-party solution, built using Fabric Extensibility Toolkit (FET) and Azure AI Foundry integration, delivering reconciled, governed, analytics and AI‑ready financial data directly into a customer’s Lakehouse and Eventhouse.

Why Capital Markets data is uniquely hard to reconcile and why it matters

Capital Markets operate with some of the most complex data in any industry:

Hundreds of external and internal data sources such as prime brokers, custodians, market data providers.

  • Thousands of portfolios, instruments, and entities, each represented by multiple identifiers across financial systems.
  • Continuous lifecycle events such as corporate actions, accruals, net/gross position changes.
  • Real‑time expectations where intraday data matters and end‑of‑day data is already stale.
  • Strict governance requirements around entitlements, PII, cross‑jurisdiction data residency, and auditability.
Simply ingesting data from different sources as “raw data” is not enough. Without applying the financial taxonomy, semantics, reconciliation logic, and entitlement controls, data remains fragmented and is not ready for use.

What is Capital Markets DataHub workload?

Capital Markets Datahub workload is not another generic warehouse. Instead, it is a financial data product and workload that makes Microsoft Fabric Capital Markets aware by embedding industry‑specific intelligence directly into the data layer.

At a high level, Capital Markets Datahub provides:

  • 200+ Capital Markets connectors to banks, custodians, prime brokers, administrators, and market data providers
  • A single Canonical Capital Markets data model that normalizes instruments, positions, trades and many more.
Built‑in reconciliation logic (> 99% accuracy) to resolve breaks and inconsistencies across providers
  • Financial Services‑specific entitlements layered on top of Fabric governance
  • AI‑ready datasets that Copilot and models can safely consume
The results in offering a solution that’s a single pane of glass available as a fully integrated experience with Fabric Lakehouse, Eventhouse, Power BI, notebooks, and extending to Azure AI Foundry and Microsoft Excel integration.

How Capital Markets Datahub works on Microsoft Fabric

Capital Markets Datahub workload is built using the Fabric Public REST APIs, tools and client SDKs made available in the Fabric Extensibility Toolkit that allows them to offer a unified and integrated experience to Fabric customers using their workload.

The workflow from data preparation, data delivery and data consumption goes through the following steps.

The_workflow_steps_from_Data_Preparation_to_Data_ConsumptionThe_workflow_steps_from_Data_Preparation_to_Data_Consumption

Figure: Schematic diagram of the E2E dataflow from ingestion to publish.

This turns Microsoft Fabric into a platform that now offers a Capital Markets‑ready data and AI data platform. Given financial services is a highly regulated industry the datahub solution also enforces zero trust AI by implementing fine grained security to manage business entitlements so users can see and interact with what they are authorized to see.

As a result, on top of the foundational datasets stored in OneLake, Capital Markets Datahub provides a custom natural language interface called Ask Datahub to its customers allowing users to ask questions such as:

  • “Explain today’s exposure changes by strategy and sector.”
  • “What is the latest Month- to- Date P&L by asset type?”
  • “Summarize risk drivers impacting the portfolio this week.”
Because the data is reconciled, governed, and permissioned, Copilot and Agentic workflows can operate safely to deliver real business value. For Microsoft customers, this brings together the best of Fabric, Azure, and Copilot packaged in a workload to support some of the most data‑intensive and high‑value financial industry use-cases.

How the workload delivers value to customers

With Capital Markets Datahub on Microsoft Fabric, businesses can
  • Reduce manual data wrangling and reconciliation effort
  • Unify portfolio, risk, operations, and investor reporting on a single data foundation
  • Accelerate time to value for analytics and AI initiatives
  • Improve transparency and auditability for regulators and clients
  • Enable AI adoption without compromising data security or governance

Get started

Capital Markets DataHub will be available as a Microsoft Fabric workload in the Fabric Workload Hub, offering Financial Industry customers and partners a path to explore the Capital Markets‑ready data foundation and tools on Microsoft Fabric.

To get started, navigate to the Fabric Workload Hub and add Capital Markets DataHub to your tenant.

Check out the demo video to learn about the complete end to end experience and features.

Workload_Hub_on_Fabric_with_Capital_Markets_Datahub_highlightedWorkload_Hub_on_Fabric_with_Capital_Markets_Datahub_highlighted

Figure: Schematic diagram of the E2E dataflow from ingestion to publish.

Additional resources

To learn more about the offer refer to the Azure Marketplace.

Refer to the Product Documentation for more information.