Delete the file from SharePoint location
Hi All, I am trying to copy the files from Share Point to ADLS and referring to the below URL pipeline to achieve the copy functionality. https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/ I need…
How to add Auth Headers in REST Linked Service in Azure Data Factory (ADF) when using oAuth2 Client Credentials?
My API provider requires an API-Key additional header when using oAuth2 Client Credential to generate access token. In Azure DataFactory, when I create a REST linked service using OAuth2 Client Credential as authentication type, I also include Auth…
How to fix "Failure happened on 'Source' side A task was canceled" error
Data load from Salesforce object with 1million records fails with the below error in Azure Data Factory: Failure happened on 'Source' side. 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' The data load…
ADF lost access to Dynamics CRM / Dataverse after MFA was turned on
Today my ADF pipelines started throwing errors: Operation on target Process order failed: ErrorCode=DynamicsFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to connect to Dynamics: Unable to Login to…
Azure data factory pipelines stopped working because return pipeline variables are not longer recognized run time
Hi, My pipelines code has not changed for over 3 weeks and until yesterday there were no issues. All pipelines fail due to same issue: pipeline return variable set in child pipeline is not longer recognized in parent pipeline. System complains that…
Failed to convert the value in 'container' property to 'System.String' type. Please make sure the payload structure and value are correct.
We are creating a Pipeline consisting of some Lookup Activity, Set Variables and Copy Activity using REST APIs provided by Azure Data Factory. Pipeline has some parameters and Variables defined at Pipeline level and at Data set levels. Pipeline and its…
filter and lookup transformation
Hi, have 2 tables table1 .jobid 1 table2 tjob2.jobid1 and jobname='test' how to filter jobid1 where jobname<>'test'
Not able to connect to on premise sql server using self integration run time in azure data factory
I am able connect to on premise sql server using SSMS tool but while connecting through azure data factory using self hosted integration runtime and linked service getting below error. No mistakes in user name and password .Please help me on this. { …
how to split a csv file based on columns.
Hi Team, There is a scenario in which we have to split columns of a CSV file into unique files in blob. for example let's say I need to create each file based on the combination of (TimeStart + TimeEnd + A) i.e. three columns per file and filename would…
How can we run the different level of folders in a heirarchy in batches?
I have a doubt if we can approach something like this in ADF. I have created a for each activity where I'm iterating through an array of folders. Let's say I'm passing folder I'd of A and then I'm calling a pipeline in for each that will return sub…
Data Factory - No erorrs
Hi In Data Preview tab I'm getting a message like "Transformation stream is invalid, fix errors to enable data preview. Click to see errors" But when I click to see errors there is no errors. What should I do?
Solutions Architect Expert Certification
Hello, I unfortunately lost access to my microsoft learn account because of my previous company, so I could not renew my AZ104 exam. Today I just passed the AZ-305 exam, I would kindly ask you to provide me the opportunity to renew my AZ-104 exam so I…
Using Entra ID Auth Only in ADF + Azure SSIS IR solution
Hi, We're currently working on complying with Microsoft cloud security benchmark in our tenant and ran into an issue with our Azure Data Factory service. To comply, we need to have only Entra ID Auth on our Azure SQL DBs. We're using Azure Data Factory…
Takes more time for a data to get uploaded
The data that I upload it takes more time to index, that was around only 2kb but it is 1 day now still it is indexing is there anything I should do
pipeline fail during the sink of a copy data to parquet
I have an issue with a pipeline that works just fine with the same resources (storage account, linked server and integration runtime) in a different ADF (TEST env), in PREPROD, the difference is that the IR is shared as it comes from the TEST env, it…
Copy Data Activity failes on datatype uniqueidentifier when Staging is enabled and no column mapping configured.
Using Azure Data Factory Copy Data Activity from Azure SQL Database to Azure Synapse Analytics. The Copy Data Activity failed with InvalidCastException error 'The given value of type String from the data source cannot be converted to type…
ADF deployment issue
Hi, I am using Azure data factory and setup different branches for developers. I have setup adf publish branch as well so that when developers are done with their changes, we can publish the changes to adf publish branch and then from that branch I can…
Azure Data Factory: Fetch xml to return all the attributes not working properyl
Hi, Thanks in advance for your response. I am using copy activity to copy the data from one environment to another environment in dynamics 365. If I dint use any filter in the fetch xml query, it works fine. Otherwise i am getting missing key…
"No result available for stream" error when performing join and previous step uses cached lookup
I have a data flow where I look up and cache rows that have been updated as part of an ETL pipeline. I then want to join that updated data with the existing data in the target database. The problem seems to be that when doing the join operation the part…
Unable to resolve Azure database for mysql name from Data Factory
I am creating a linked service from my Azure Data Factory environment, to access my Azure Database for Mysql database. I select "Azure database for Mysql", and I can see all my mysql servers. I select "From Azure subscription" as the…