Bug Report: Copy Activity fails with PathNotFound when source Delta table is empty in Micro
I would like to report a bug in Microsoft Fabric's Copy Activity when the source is an empty Delta table in a Lakehouse.
**Environment:**
- Service: Microsoft Fabric
- Activity: Copy Activity
- Source: Lakehouse Delta Table
- Destination: Fabric Warehouse Table
**Issue Description:**
When the source Delta table is empty (0 records), the Copy Activity fails with the following error:
ErrorCode=UserErrorFileNotFound
Message: ADLS Gen2 operation failed: Operation returned an invalid status code 'NotFound'.
ErrorCode: 'PathNotFound' - The specified path does not exist.
Path references an internal Staging path: 'MSSQLImportCommand'
**Steps to Reproduce:**
1. Create a Copy Activity in Fabric Pipeline
2. Set Source to a Lakehouse Delta Table that is empty (0 records)
3. Set Destination to a Fabric Warehouse Table
4. Run the pipeline
**Expected Behavior:**
The Copy Activity should complete successfully with 0 rows copied, similar to how it behaves in Azure Data Factory.
**Actual Behavior:**
The Copy Activity fails with PathNotFound error related to an internal staging path that is not created when the source is empty.
**Impact:**
This forces users to implement workarounds (e.g., Spark Notebook checks before Copy Activity) to avoid pipeline failures, adding unnecessary overhead and latency to data pipelines.
**Additional Notes:**
- The issue does not occur when the Delta table contains data
- The staging linked service cannot be manually configured in Fabric Copy Activity (unlike ADF), so there is no workaround within the activity itself
Please advise on a fix or official workaround.
Thank you.
Recent ideas
Bulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401972 hours agoFrequent VisitorNew2Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf11 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde13 hours agoSuper UserCompleted1.4KViews6likes4Comments