BCP — Microsoft Fabric Roadmap

Description

Fabric Data Warehouse will support the bcp utility and the TDS Bulk Load API, enabling high-performance data ingestion from a variety of client tools such as bcp, SSIS, and Azure Data Factory. This integration simplifies bulk data loading into Fabric DW and supports scalable, efficient workflows. Centralized support for these APIs ensures consistency across ingestion pipelines and improves interoperability with existing tools.<br/>An example of a bcp command that loads file content into a DW table:<br/>```bcp dbo.artists in gold_artist.txt -d TextDW -c -S myworkspace.datawarehouse.fabric.microsoft.com -G -U theuser@microsoft.com ```

📰 Related Blog Article

Using Bulk Copy API for faster ingestion in Fabric Data Warehouse (Preview)

🔗 community.fabric.microsoft.com

Change History

2026-07-29

Release Status Planned -> Shipped
2026-06-16

Restored to Roadmap
2026-06-16

Removed from Roadmap
2026-05-13

Release Date 2026-09-21 -> 2026-06-30
2026-04-02

Release Date 2026-04-20 -> 2026-09-21
2026-03-26

Release Date 2026-03-31 -> 2026-04-20
2026-01-13

Release Date 2026-01-27 -> 2026-03-31
2025-11-05

Release Date 2025-11-29 -> 2026-01-27
2025-10-14

Feature Description Fabric DW will support bcp utility and TDS Bulk Load API. Bulk Load API enables a variety of client tools like bcp SSIS ADF to load data into Fabric DW. An example of bcp command that is loading a content of a file into the DW table is:```bcp gold.artists in "C:\temp\gold_artist.txt" -d TextDW -c -S "<server name>.datawarehouse.fabric.microsoft.com" -G -U theusert@microsoft.com ``` -> Fabric Data Warehouse will support the bcp utility and the TDS Bulk Load API enabling high-performance data ingestion from a variety of client tools such as bcp SSIS and Azure Data Factory. This integration simplifies bulk data loading into Fabric DW and supports scalable efficient workflows. Centralized support for these APIs ensures consistency across ingestion pipelines and improves interoperability with existing tools.<br/>An example of a bcp command that loads file content into a DW table:<br/>```bcp dbo.artists in gold_artist.txt -d TextDW -c -S myworkspace.datawarehouse.fabric.microsoft.com -G -U theuser@microsoft.com ```
2025-09-22

Release Date 2025-09-27 -> 2025-11-29
2025-08-28

Roadmap Item Added