FABRIC + FOUNDRY IQ

Flight Data Profile

US DOT Flight Operations 2015 — Fabric Lakehouse: airline_flights

5,819,079

Total Flights

Airlines

9.0

Avg Delay (min)

89,884

Cancelled

Try Semantic JOIN

Select a preset question, then click Search to see the demo in action.

Try:💡 Offline? Try simulation mode →

FABRIC IQ — STRUCTURED

flights table

5.8M rows — US airline operations 2015

Waiting for query...

Semantic JOIN

FOUNDRY IQ — UNSTRUCTURED

DOT policy PDFs

4 documents — passenger rights & regulations

Waiting for query...

SEMANTIC JOIN — UNIFIED ANSWER

Data lives everywhere — Foundry IQ searches it as one.

SharePoint, Fabric OneLake, Azure Blob Storage, the web — wherever your enterprise data lives, one Knowledge Base unifies it all. One API call. Multiple sources. Cited answers.

What is Foundry IQ? — Microsoft Learn →Foundry IQ Deep Dive — Tech Community →

One Question, Two Brains

"Numbers come from Fabric, reasons come from Foundry IQ."

Phase 3 demonstrates Semantic JOIN — a single question answered by combining structured data (this flight dataset from Fabric) with unstructured documents (DOT regulation PDFs indexed via Foundry IQ).

This is not a SQL JOIN. The LLM reasons across both sources and synthesizes a unified answer with citations from each.

Fabric IQ — Structured

flights table (5.8M rows)

Delay counts, cancellation stats, route data

→ "2,566 flights delayed 2+ hrs at JFK"

⚡

Semantic
JOIN

Foundry IQ — Unstructured

DOT Policy PDFs (4 docs)

Passenger rights, compensation rules, regulations

→ "Full refund for 3+ hr delays per DOT"