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
About "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...Jarrinf41 minutes agoFrequent VisitorNew47Views3likes2CommentsEventstream 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...svelde1 hour agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi2 hours agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg10 hours agoNew MemberNeeds Votes7.8KViews1154likes104Comments