Forum Discussion
error with copy data activity
I have a pipeline that uses several data copy activities to transform Excel delta tables from SharePoint folders with shortcuts into Excel delta tables.
It hasn't been working for the past couple of hours because the activity is unable to read the file path.
I've tried configuring a new activity, but it generates an error because it can't see the “Files” tables.
Genrique
This seems to be temporary issue, you need to check if the shortcut created still exists, sometimes shortcuts disconnect or expires.
Refresh the lakehouse explorer file section.
Verify that source excel file in sharepoint is not locked.
If nothing works then try re-creating shortcuts connection again, sometimes , fabric sometimes catches the folder metadata.
If this helps, ✓ Mark as Kudos | Help Others
2 Replies
- Murtaza_GhafoorSuper User
Genrique
This seems to be temporary issue, you need to check if the shortcut created still exists, sometimes shortcuts disconnect or expires.
Refresh the lakehouse explorer file section.
Verify that source excel file in sharepoint is not locked.
If nothing works then try re-creating shortcuts connection again, sometimes , fabric sometimes catches the folder metadata.
If this helps, ✓ Mark as Kudos | Help Others
- GenriqueFrequent Visitor
It seems to have been fixed. Thanks!