Forum Discussion
Skip line count missing in copy activity
Hi KimTutein
Thanks for reaching out to Microsoft Fabric Community Form.
Microsoft Fabric's Data Factory currently lacks support for the "skip line count" option when reading delimited text files in copy activity. In Azure Synapse, users had the ability to skip header rows or unwanted lines, but this functionality is not yet available in Fabric.
If you need to skip lines, you can use PySpark in a notebook to filter out specific rows during data ingestion.To request this feature, you can submit an idea to the Microsoft Fabric Ideas forum. Microsoft reviews user requests, and popular features may be added in future updates.
When submitting, explain how this feature helped in Synapse and why it is needed in Fabric.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.Best Regards,
Community Support Team _ C Srikanth.
Hi KimTutein
Thanks for reaching out to Microsoft Fabric Community Form.
Microsoft Fabric's Data Factory currently lacks support for the "skip line count" option when reading delimited text files in copy activity. In Azure Synapse, users had the ability to skip header rows or unwanted lines, but this functionality is not yet available in Fabric.
If you need to skip lines, you can use PySpark in a notebook to filter out specific rows during data ingestion.
To request this feature, you can submit an idea to the Microsoft Fabric Ideas forum. Microsoft reviews user requests, and popular features may be added in future updates.
When submitting, explain how this feature helped in Synapse and why it is needed in Fabric.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.