Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,571 questions
2 answers
How to automatically rerun failed pipeline in ADF?
I have pipeline PL_Final like... Lookup --> Execute Pipeline1 (data ingestion) --> Execute Pipeline2 (data flow) --> Execute Pipeline3 (data flow) --> Execute Pipeline4 --> Execute Pipeline5 --> Stored Procedure Schedule trigger created…
asked 2024-03-20T17:08:30.3433333+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(38.4, 98%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anuganti Suresh
200
Reputation points
answered 2024-05-01T08:26:03.9233333+00:00
Pinaki Ghatak
2,395
Reputation points Microsoft Employee
2 answers
How to read excel document from sharepoint directly dump it in Azure SQL using Azure data factory ?
I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use data factory to read the content of it and directly dump it in Azure SQL.
asked 2024-04-15T07:24:19.01+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, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
heta desai
247
Reputation points
commented 2024-05-01T08:25:11.8666667+00:00
AnnuKumari-MSFT
30,986
Reputation points Microsoft Employee
1 answer
How to configure VNET DNS resolution for two different linked domains at the same time?
Hi, We have a domain on-prem which is connected via VPN tunnel to a Virtual Network Gateway in Azure, linked to this is a Virtual network and this is also peered to a number of other vnets but along with it there is another different domain in there. I…
asked 2024-04-30T13:45:10.76+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(185.6, 61%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB5%3C/text%3E%3C/svg%3E)
Benollins-5339
0
Reputation points
commented 2024-05-01T08:25:01.4+00:00
Benollins-5339
0
Reputation points
2 answers
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
asked 2024-04-27T14:28:52.5466667+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, 10%, 21%)' 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)
Sondre Dahl
0
Reputation points
commented 2024-05-01T08:24:37.3366667+00:00
Sondre Dahl
0
Reputation points
2 answers
Configuring Linked Service for Dev to Prod Movement in Azure Synapse Analytics
In Azure Synapse Analytics, I have a linked service of type Azure SQL Database Managed Instance, and I have two linked services, one for dev and one for prod. How can I move from dev to prod without changing the linked service manually? How can I make it…
asked 2024-04-15T07:21:19.3566667+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(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aditya Singh
105
Reputation points
commented 2024-05-01T08:23:25.0033333+00:00
AnnuKumari-MSFT
30,986
Reputation points Microsoft Employee
4 answers
how we can get latest sub folder from the main folder using ADF
how we can get latest sub folder from the main folder using ADF ex: folder -->folder1, folder2 in the above ex i need latest sub folder ?
asked 2024-03-22T09:01:55.3433333+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(32, 43%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bommisetty, Rakesh (Hudson IT Consultant)
165
Reputation points
answered 2024-05-01T08:21:49.57+00:00
Pinaki Ghatak
2,395
Reputation points Microsoft Employee
3 answers
How does large on-prem SQL database with multiple files fill up
I got a large database with one filegroup having multiple data files spread across 2 disks. But one of the 2 disks is larger than other, with all data files on both disks have Autogrowth disabled, and the value "is_autogrow_all_files" is set…
asked 2024-04-30T07:00:47+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(217.60000000000002, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kumar
1
Reputation point
commented 2024-05-01T08:21:35.6566667+00:00
Erland Sommarskog
101.1K
Reputation points MVP
1 answer
Data flow: toBase64 adds break lines after 76th character in specific ADF location
Hi! Recently we've got unexpected outputs from ADF pipelines with no prior changes to the source code. Suddenly, the toBase64 function in data flow activities began to add break lines (\r\n) after the 76th character for output values. During the issue…
asked 2024-04-26T08:01:34.9833333+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(144, 79%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Andrii Danyl'tsiv
0
Reputation points
commented 2024-05-01T08:20:34.5066667+00:00
Amira Bedhiafi
15,446
Reputation points
1 answer
Exchange 2016 HMA - Unable to sign into outlook for iOS/Android
Hi, My organization is using Exchange Server 2016 CU23 Apr24HU. We have established a hybrid configuration with our GCC tenant. Recently we are no longer able to log on-premises users into the outlook mobile application. They authenticate successfully…
asked 2024-04-24T15:50:34.6666667+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(310.4, 93%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Michael Herman
0
Reputation points
commented 2024-05-01T08:19:07.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(70.4, 18%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Noah Ma-MSFT
610
Reputation points Microsoft Vendor
1 answer
Sims 4 from one user to another
My mom and I kind of share a laptop, and I've been playing the Sims under her user login thing. I've got my own, and that's where I want to play, but I don't want to have to start from scratch, and I really haven't been able to just figure out a way to…
asked 2023-04-08T00:00:17.35+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(316.8, 17%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
amber-lee m
0
Reputation points
commented 2024-05-01T08:18:41.95+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(172.8, 32%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alfredojefferson
0
Reputation points
1 answer
One of the answers was accepted by the question author.
General Availability Estimate for Newest Baselines
The following baselines in Microsoft Intune Endpoint Security is in preview: Security Baseline for Windows 10 and later (Version 23H2) Security Baseline for Microsoft Edge (Version 117) Microsoft 365 Apps for Enterprise Security Baseline (Version…
asked 2024-05-01T06:23:16.59+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(243.2, 56.00000000000001%, 33%)' 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)
Christian Berg Smith
0
Reputation points
accepted 2024-05-01T08:16:24.3633333+00:00
Christian Berg Smith
0
Reputation points
1 answer
The query behind the Sentinel Open | New | Active incident widget
Hi, We are trying to figure out what query produces the following numbers in Sentinel We've been trying to produce the same numbers using the SecurityIncident and SecurityAlert table, but the number of incidents are much less than showed here. I'm…
asked 2024-04-22T11:45:44.6766667+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, 62%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Laszlo Pal
20
Reputation points
edited a comment 2024-05-01T08:15:56.15+00:00
Clive Watson
5,716
Reputation points MVP
1 answer
New azure portal layout?
What's with the awful new layout? Any way to select the old one?
asked 2024-04-25T13:42:31.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(310.4, 96%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Andrew Williamson
0
Reputation points
commented 2024-05-01T08:15:51.4133333+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, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Paul Smith
0
Reputation points
3 answers
intune company portal android devices question
How can I exclude a user group in Intune from the Company Portal on Android devices so they can install Teams and Outlook without needing to install the Company Portal? Thank you.
asked 2024-05-01T06:16:43.61+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(185.6, 33%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Christos Christopoulos
0
Reputation points
commented 2024-05-01T08:15:38.3833333+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(233.6, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Crystal-MSFT
43,126
Reputation points Microsoft Vendor
3 answers
Filtering data for last 24 months in Mapping Data Flows
How can I filter data using Mapping Data Flows for the last 24 months, starting from the max date and going back? The date column is in the mm/dd/yyyy format.
asked 2024-03-19T01:29:58.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(176, 41%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ADITYA SINGH
0
Reputation points
edited an answer 2024-05-01T08:15:23.97+00:00
Pinaki Ghatak
2,395
Reputation points Microsoft Employee
2 answers
how to reschedule an exam?
How to reschedule the microsoft certification exam
asked 2024-03-17T17:22:57.6833333+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(41.6, 92%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mahadev, Ananya
35
Reputation points
commented 2024-05-01T08:13:27.8033333+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(304, 93%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ajkop
0
Reputation points
1 answer
How to visit the views of carouselview different item ?
webview will display embed youtube video I need user webview.EvaluateJavaScriptAsync to control the video. Then, how can i visit the webview of different items ? <CarouselView Grid.Row="2" x:Name="cView"…
asked 2024-04-29T07:10:20.56+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(208, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFX%3C/text%3E%3C/svg%3E)
Fei Xu
490
Reputation points
answered 2024-05-01T08:12:35.9666667+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(182.40000000000003, 82%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDI%3C/text%3E%3C/svg%3E)
Digital Iflextech
0
Reputation points
2 answers
How to update and delete a row using Azure Data Factory Change Data Capture
I am exploring Azure Data Factory CDC feature, and I am trying to perform the CDC from one SQL table to another SQL table, also the SQL table in the source has a primary key. Whenever a new row is added to the source table, it gets added to the…
asked 2024-04-28T17:40:36.5966667+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(16, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jigsm
236
Reputation points
commented 2024-05-01T08:12:32.8433333+00:00
Amira Bedhiafi
15,446
Reputation points
3 answers
Whats next after setting organizational relationship in EAC
Hi We have a partner organization (external M365 tenant) and we want them to be able to reserve meeting rooms using our room resource calendars. After I create an organizational relationship using instructions from…
asked 2024-04-29T08:34:44.29+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, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
IMK
401
Reputation points
commented 2024-05-01T08:10:06.6066667+00:00
Noah Ma-MSFT
610
Reputation points Microsoft Vendor
2 answers
Correct way to convert 365 tenant from AAD Connect Sync to cloud-only
Hi, about a year ago, one of my customers has enabled AAD Connect Sync to synchronize all users, security groups from their existing on-premise Active Directory to a freshly setup Microsoft 365 tenant. This past year all applications and services have…
asked 2024-04-30T15:08:44.93+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(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Caspar - ABO
166
Reputation points
commented 2024-05-01T08:09:12.8066667+00:00
Caspar - ABO
166
Reputation points