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
Set 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_Krieg2 hours agoNew MemberNeeds Votes7.8KViews1154likes104CommentsTable Visual — Rounded Corners and Pill-Style Cell Backgrounds
Add the option to display cell background colors as rounded rectangles or pill-shaped labels within the native Table visual. Currently, applying a background color fills the entire cell with a solid...urawizardharry3 hours agoRegular VisitorNew8Views0likes0CommentsAdd Global Alignment Controls for Power BI Matrix Values and Headers
Please add a global alignment setting for Matrix visuals that allows users to apply the same alignment, left, center, or right, to all measure columns at once. This should apply to column headers, d...AaronReasoner4 hours agoNew MemberNew2Views0likes0CommentsCase sensitive-insensitive option in Power BI
There should be an option in Power BI for the data in the columns to be either case sensitive or insensitive. When one deals with data involving client names or entity names, case sensitivity-sinsens...sohail_syed_moh4 hours agoNew MemberNeeds Votes2.3KViews124likes11CommentsGoverned & Regulation for Publish to Web feature
Notifying certain group of individuals if there is any enhancements performed on the semantic model which already hold an active Publish to Web code in place. This ensure in having more security and...Jaswanth_UNHCR5 hours agoNew MemberNew2Views0likes0Comments