Forum Discussion
AdlsGen2ForbiddenError on Fabric Data Warehouse staged copy for one large table (after ~1 hour)
Hi wardy912 , nielsvdc
Thanks for your reply.
With my use cases,
wardy912, I cannot have multiple copy data activities at the same time within the ForEach
nielsvdc As I use built-in enable staging, I am unable to use a service principal for authentication, and splitting the copy activity into smaller batches will not work for me.
I solved the issue by using external storage instead of workspace storage.
Super User
The error is most likely caused by credential/token expiry. Common triggers include short-lived SAS tokens (default ~1 hour) or OAuth tokens that aren’t refreshed mid-run. Other tables succeed because their runs finish before expiry.
Try splitting the pipeline down using a ForEach so that you can use the token for multiple copy activities at the same time, or paramterise so that the token refreshes after a certain time.
--------------------------------
I hope this helps, please give kudos and mark as solved if it does!
Connect with me on LinkedIn.
Subscribe to my YouTube channel for Fabric/Power Platform related content!