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
Slicer option to show no data when no value is selected
Hello Power BI Team, Description: Currently, when the "Select All" option is enabled in a slicer, selecting it displays all related values as expected. However, when "Select All" is de-selected and...74075450 minutes agoNew MemberNew2Views0likes0CommentsParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v2 hours agoCommunity ChampionNew10Views1like0CommentsAutomatically match PowerBI chart background color to Powerpoint slide background color
Export PowerBI to PowerPoint slide - Can we define the PowerBI export background color to automatically match the PowerPoint slide background color ? By Default, the PowerBI background color is Whi...jim_chan6 hours agoNew MemberNew7Views0likes0CommentsNew Card Visual - Alignment of Reference Label Values
The latest Power BI Desktop version I'm allowed to use at work currently is Version 2.154.1260.0 (May 2026), so if this request has already been implemented in later versions, please disregard. Othe...nk685f7 hours agoAdvocate INew9Views0likes0Comments