How the connector works
The connector lands every EDI document in Microsoft Fabric as structured, queryable rows — not raw X12 blobs. Orders, ship notices, invoices, POS activity, and remittances arrive with keys intact, so fill-rate dashboards, deduction analytics, and demand models build on live trading data instead of exports.
| Microsoft Fabric object | EDI document | |
|---|---|---|
| Order-lifecycle tables | ← | 850 Purchase Order |
| Shipment / fill-rate tables | ← | 856 Ship Notice / ASN |
| Invoice & deduction tables | ← | 810 Invoice |
| Store-level POS tables | ← | 852 Product Activity Data |
| Settlement tables | ← | 820 Remittance Advice |
Supported transaction flows
Purchase Order
The order a trading partner sends you. Process same day, never re-key.
Ship Notice / ASN
The carton-level shipment mirror that must arrive before the freight does.
Invoice
Your bill for the shipment. Must reconcile with the PO and the ASN.
Product Activity Data
Store-level sales and stock movement from the retailer.
Payment Order / Remittance Advice
What the partner paid and why — deductions itemized.
Setup: the wizard does the work
Partners commonly paired with Microsoft Fabric
Walmart EDI
Mass & Club · AS2
Target EDI
Mass & Club · SFTP
Kroger EDI
Grocery · AS2
Costco EDI
Mass & Club · VAN
Best Buy EDI
Electronics · AS2
Dollar General EDI
Discount · AS2
Microsoft Fabric EDI FAQ
How does EDI data land in Microsoft Fabric?
As structured tables, continuously — order lines, shipment hierarchies, invoice lines, and POS activity with keys preserved, ready for joins. No X12 parsing on your side.
Do I need EDI middleware between Microsoft Fabric and my trading partners?
No. EDISQ is the translation, validation, and transport layer in one — certified partner maps, AS2/SFTP/VAN connectivity, and acknowledgment tracking are all included.
What does it cost?
Per document only: first 25/month free, then from $0.50, decreasing with volume. The connector itself costs nothing — no per-connector or per-partner fees.