This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 91%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I'm trying to ingest data into ADX tables through Foreach/copy data activity in ADF..
and now I'm getting this error.
what does this error mean and how can I solve it?
Thank you for any help in advance!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hello @jkj ,
Just checking in to see if the below suggestion provided by @VinodKumar-0434 was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same.
And, if you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
@VinodKumar-0434 I am getting notified. Is my email somehow set up on your account?
Hi @Anonymous ,
Looks like you are following this question and you may have configured your notifications for the tags and questions you are following which is why you may be receiving the email notifications. If you donot want to receive those notifications, please unfollow the question and tag.
For more information about Q&A notifications please refer to this article : MS Q&A Email notifications
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 3%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV0%3C/text%3E%3C/svg%3E)
Hi @jkj , By design lookup activity has a limitation of 5000 rows in the result set.
Here is the reference
But you can use a work around as in the below link
Please upvote if you find the answer useful. Thanks.
Hi @jkj , Hope you are doing good. Would like to check if you are able to fix the issue with the provided answer. If yes, could you please upvote the answer.
@VinodKumar-0434
Sorry again. I am getting notification from my email on your previous reply..
Hi @jkj , could you please let us know if my answer helped you?