30 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
52
views
Is there a way to ignore columns with no name in a copy data activity in ADF?
I'm using a copy data activity to move data from excel files to a db. In the mapping I added the column names that should come in the excel file. Sometimes files come with columns without a name and ...
0
votes
1
answer
66
views
How to create a log file containing the name and timestamp of files copied from a storage account to another in Azure Data Factory
I am looking for a way to create a log file for the files copied from one storage account to another. This log file should be a CSV file and contain the names and timestamps of all copied files.
I ...
0
votes
0
answers
115
views
Reference JSON Response in Copy Activity in Data Factory
I have a Copy Data activity in a Microsoft Fabric Data Factory pipeline.
The activity connects to a REST API and writes the resultant JSON file to a folder in a lakehouse. I would like the destination ...
0
votes
1
answer
704
views
Pagination Parameters in Fabric Data Factory Pipeline
I am struggling with implementing pagination for a REST API in a Microsoft Fabric Data Factory pipeline. I have read the official Microsoft documentation and have tried various things but to no avail. ...
0
votes
1
answer
217
views
ADF REST API Put requests
I want to use ADF to bulk update records with SQL as the source and a REST API as the sink.
The API doesn't allow a bulk update with all data in a JSON format in a single request. My dataset is 2.5k / ...
0
votes
1
answer
435
views
Azure Data Factory: "Quote all text" inactive in Copy Data activity
I have an existing working pipeline in ADF. However, output CSV file in the storage container has every value enclosed in double quotes. I need to get rid of double quotes.
I presume, this happens ...
1
vote
1
answer
209
views
Access the source data in pre-copy script in copy data activity
I am trying to access the some data stored in container in blob storage in copy data activity. In the source settings I am able to specify the dataset for the source file , now I want to access the ...
0
votes
1
answer
122
views
Unzip zipfile which contains subfolders stored in blob storage using Azure Data Factory
I want to extract all files and folders from a zipfile which is stored on an Azure Blob Storage. The extracted data should be stored in a output folder.
I have a zipfile stored in Azure Blob Storage. ...
0
votes
1
answer
52
views
How do I run a vba code every time a cell in a specific row changes?
I currently have a vba code that copies data from one worksheet to a number of new worksheets depending on the option chosen from a drop down list in column D.
I need this code to run everytime the ...
1
vote
1
answer
39
views
Unable to get VBA code to work which allows data to be copied from one worksheet to another based on the selection of data from a drop down list
How can I copy the entire row to another worksheet based on the chosen item out of a dropdown list. If option 1 in Cell E2 which contains a dropdown list is selected I want to copy the row to ...
0
votes
1
answer
279
views
Unable to specify wwilakehouse as Destination Lakehouse in Microsoft Fabric
I am a beginner in using Micrsoft Fabric. Currently I follow the Lakehouse tutorial to create an end-to-end data pipeline.
In step 4 Ingest data after building a lakehouse, I would like to specify ...
0
votes
0
answers
44
views
How do I copy a row into each of the following tab after it based on one column response?
example pic: (https://i.sstatic.net/jxMUF.png)
In Google Sheets, I want to take the data from the 1st tab and transfer only the rows that show monthly expenses to the following tabs.
So based on the ...
0
votes
1
answer
452
views
Logic App to check the Azure blob container for new files and send email notification
Im trying to achieve the following scenario and have searched the net for days and even tried to get Chat GPT to help but didnt get anywhere. Any help with this would be greatly appreciated.
I have ...
0
votes
1
answer
400
views
Error while copying files from blob to snowflake through ADF : Encrypted excel file 'Reports.csv' is not supported, please remove its password
I am facing below error , while loading data from azure blob to snowflake:
ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted ...
0
votes
1
answer
251
views
Adding Current Date to DB Sink Mapping
I am currently using our Data Factory to fetch an .xlsx file from an open API, and then write the data to a table in our database. For this task, I use two copy activities. One of them copies the file ...