I am getting the below mentioned error, while ingesting data through ADF from Azure SQL to Azure Data Explorer. linked service connection failing when giving connection at destination(i.e. ADF to ADX)
ErrorCode=UserErrorKustoWriteFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failure status of the first blob that failed: Insufficient security permissions to execute request,Source=Microsoft.DataTransfer.Runtime.KustoConnector,'
please help in solving this issue