Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,142 questions
1 answer
Excel to SQL DB Table :Column Space truncated
Hi, I am facing an issue while copying data from excel to Azure SQL DB, I am using a simple copy activity. If I have a trailing space at the end of column value, that space is truncated. for Eg, i have a colun 'client' , and one of the values is 'airtel…
asked 2024-07-19T06:56:57.6033333+00:00
![](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(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
205
Reputation points
answered 2024-07-22T07:42:18.2566667+00:00
Olaf Helper
43,166
Reputation points
0 answers
Change Data Capture preview feature not working
I am trying to perform some poc by using change data capture feature which is in preview, but I am not able to see table results. I create a connection with Azure SQL Database and get a succesful connection, but when I try to fetch tables every time its…
asked 2024-07-22T07:31:37.3133333+00:00
![](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(73.60000000000001, 32%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anmol Ganju
166
Reputation points
asked 2024-07-22T07:31:37.3133333+00:00
Anmol Ganju
166
Reputation points
1 answer
How to have back of everything for Azure Active Directory?
I want to have backup of everything from Azure Active Directory. How to do it whats the procedure please help me guide it. If 3rd software also can be used Please help. I use Azure active directory and Intune.
asked 2024-07-17T14:47:17.2833333+00:00
![](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(297.6, 34%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TestUser
40
Reputation points
commented 2024-07-22T07:30:44.6966667+00:00
![](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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
240
Reputation points Microsoft Vendor
3 answers
How to generate ETL pipeline for Python code which gives 2 JSON file in response
Requirement : I have python code in my local pc folder which returns 2 JSON file as a output (that code is using API and try to store the data of website in JSON file), I want to create automation for running that python code at particular time using…
asked 2024-07-13T15:19:01.0733333+00:00
![](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, 80%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUM%3C/text%3E%3C/svg%3E)
Utsav Mori
20
Reputation points
commented 2024-07-22T07:22:52.86+00:00
![](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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NIKHILANETHIKUNTA
75
Reputation points Microsoft Vendor
1 answer
Use yaml file to create Azure Dashboards
Can we use yaml file to create Azure Dashboards. Yaml file can contain some kind of data quality validations.
asked 2024-07-09T12:16:30.68+00:00
![](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(3.2, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Harshita Vishwakarma
45
Reputation points
commented 2024-07-22T07:19:01.8233333+00:00
Harshita Vishwakarma
45
Reputation points
0 answers
Can't Copy file from SharePoint to Azure Store account
Hi, I want to copy file from SharePoint to Azure storage account. Follow the instruction here https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#prerequisites But I continuous failed in the last step,…
asked 2024-07-22T07:17:21.6533333+00:00
![](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(6.4, 90%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Chuck Wang
0
Reputation points
asked 2024-07-22T07:17:21.6533333+00:00
Chuck Wang
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How can I speak to meeesho Executive?
TO HERE you can meeesho app and go to the "Help"support team contact 0+983+1228+932+ section. Select the order for which you want to file a complaint. Choose the relevant..
asked 2024-07-22T07:13:14.5666667+00:00
![](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(28.799999999999997, 16%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
How can I speak to meeesho Executive?
20
Reputation points
answered 2024-07-22T07:13:46.76+00:00
How can I speak to meeesho Executive?
20
Reputation points
1 answer
Google drive on Azure without GCP
Hello, I'm wondering what options I have to transfer Google Drive data to Azure without GCP access. I found that the Google Drive API and Google Storage API require a Google Cloud account. What other options do I have to securely connect to and transfer…
asked 2024-07-21T12:18:22.7166667+00:00
![](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(288, 43%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tony Minozi
0
Reputation points
edited the question 2024-07-22T07:08:39.8266667+00:00
![](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(0, 59%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JananiRamesh-MSFT
23,566
Reputation points
0 answers
What is the difference between self-hosted and Azure integration runtime?
The Azure integration runtime with a managed virtual network has the same region as your data factory. It can't be auto resolved like the Azure integration runtime. The self-hosted integration runtime is located in the region of your local machines or…
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,562 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,591 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,142 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,257 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,615 questions
asked 2024-07-22T06:49:14.1766667+00:00
![](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(89.60000000000001, 15%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santo Daiz
0
Reputation points
asked 2024-07-22T06:49:14.1766667+00:00
Santo Daiz
0
Reputation points
0 answers
How to Handle Case Sensitivity in Dynamic JSON Input Keys ("A" vs "a") for Derived Columns in ADF Dataflow Pipeline?
I am working on a dataflow pipeline in ADF with an input dataset schema that includes a column 'A'. The dataflow processes various JSON files with dynamic schemas, where some JSON files use 'A' and others use 'a' as keys. Since the schema is case…
asked 2024-07-17T12:59:49.7733333+00:00
![](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(105.60000000000001, 16%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Hrithik Purwar
0
Reputation points
commented 2024-07-22T06:47:47.19+00:00
NIKHILANETHIKUNTA
75
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
how can i complain on Flipkart?
Open the Ekart app and go to the "Help"support team contact 07682_.98-3412 section. Select the order for which you want to file a complaint. Choose the relevant issue from the list of options or select “Other” if your issue is not listed??.
![](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(297.6, 46%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
3 answers
Will CRED refund money
Cred (available 24/7)hrs complaint with customer service refund money - 879 79 811 20 Issue a refund to the customer from the CRED Dashboard. Customers may cancel the order sometimes, and you may have to refund the amount....
![](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(99.2, 97%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
0 answers
How to Get Support for Contains operator for String Column in Azure Table Storage
Im using Azure table storage to log our application exceptions and it was required to search individual exception message column with certain exception word like 'AutoMapperException' or 'SqlException' etc., The contains should be a mandatory operator…
asked 2024-07-22T06:07:07.83+00:00
![](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(76.8, 85%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
shane want
0
Reputation points
asked 2024-07-22T06:07:07.83+00:00
shane want
0
Reputation points
1 answer
adf from configtable
Hi, how to load tablename from config table and using copy activity at front end... how it will execute it.... let say copy activtiy lookup for tablename then how copy activity will take that...please help with screenshot ...
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
2 answers
Integration runtime setup, Manual setup: Download and install integration runtime Page not found
I am writing to seek assistance regarding two issues I am encountering with Azure Data Factory Integration Runtime setup. Express setup Internal Server Error: Whenever I attempt to select "Option 2: Manual setup" and proceed to "Step…
asked 2024-07-16T16:50:34.3666667+00:00
![](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(115.19999999999999, 57.99999999999999%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gulam Azeemuddin
0
Reputation points
commented 2024-07-22T05:31:42.48+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
2 answers
How to send multiple files from event base trigger
Hello Team, I Hope your are doing great !!! Could you please let me know is there any way to send multiple files from storage using event base trigger. eg: now 5 files are added to my storage account event trigger is triggering 5 times, to…
asked 2022-08-05T09:20:03.357+00:00
![](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(22.400000000000002, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mahesh Totageri
21
Reputation points
commented 2024-07-22T05:19:54.9733333+00:00
![](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(70.4, 88%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gupta, Amit
0
Reputation points
1 answer
How can I export attachments to a csv from azure board?
How can I export attachments to a csv from azure board?
asked 2024-07-11T06:07:53.63+00:00
![](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(150.4, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Akhila Thankachan
0
Reputation points
commented 2024-07-22T05:01:11.4266667+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Data Factory error creating blob
Hi, I have a pipeline in Azure Data Factory that queries Cosmos DB for some data and writes this data in a blob storage. It was working until it wasn't. I changed the query in the copy activity for a specific scenario, and when I ran it again it failed…
asked 2024-07-20T12:55:13.6333333+00:00
![](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(83.2, 28.000000000000004%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Joao Borba
20
Reputation points
commented 2024-07-22T04:56:20.58+00:00
Vinodh247
13,301
Reputation points
1 answer
How to generate token for client_assertion without certificates?
We have an app registration which is connected to an external API. We have to use this API in our Azure Data factory. For this purpose, till now we were generating client secrets and generating tokens (in Azure Data Factory) from this URL -…
asked 2024-07-19T11:14:11.81+00:00
![](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(166.4, 4%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED0%3C/text%3E%3C/svg%3E)
DevanshAgarwal-0149
0
Reputation points
commented 2024-07-22T04:40:15.02+00:00
DevanshAgarwal-0149
0
Reputation points
0 answers
Data Factory monitoring by inserting data table
Hello, I would like to know the best way to insert Datafactory activity logs into my Databricks delta table, so that I can use dashbosrd and create monitoring in Databricks itself , can you help me? I would like every 5 minutes for all activity logs in…
asked 2024-07-21T22:18:21.9966667+00:00
![](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(246.4, 31%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYD%3C/text%3E%3C/svg%3E)
Yohanna de Oliveira Cavalcanti
200
Reputation points
asked 2024-07-21T22:18:21.9966667+00:00
Yohanna de Oliveira Cavalcanti
200
Reputation points