Known issue - Pipeline copy data to Kusto using an on-premises data gateway doesn't work
You can use an on-premises data gateway for a source in a pipeline. If the pipeline's copy activity uses the on-premises source and a Kusto destination, the pipeline fails with an error.
Status: Open
Product Experience: Data Factory
Symptoms
If you run a pipeline using the on-premises data gateway, you receive an error. The error is similar to An error occurred for source: 'DataReader'. Error: 'Could not load file or assembly 'Microsoft.IO.RecyclableMemoryStream, Version=$$2.2.0.0$$, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. or KustoWriteFailed.
Solutions and workarounds
The issue is fixed in the November and later versions of the on-premises data gateway. Install the latest version of the on-premises data gateway, and try again.