Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,873 questions
1 answer
One of the answers was accepted by the question author.
Importing data with Lookup fields using Azure Data Factory Common Data Service connector, when there is no ID field in source data
I have a customer who's migrating to a Common Data Service based application and needs a weekly data sync refresh. This data sync will upsert to a table from a CSV in Blob Storage to the Common Data Service for Apps connector. The CSV data provides…
asked 2020-11-05T18:06:04.3+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, 71%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Ryan Widmer
21
Reputation points
accepted 2020-11-20T21:05:29.277+00:00
Ryan Widmer
21
Reputation points
6 answers
One of the answers was accepted by the question author.
Windows Server 2019 downgrade
Hello I have a Windows Server 2019 Essentials (G3S-01299) and i want to downgrade to Windows Server 2016 Is it possible and which is the best procedure? Best Regards
asked 2020-11-20T19:02:01.34+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(67.2, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Thanasis Papamanolis
21
Reputation points
commented 2020-11-20T20:43:28.347+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(128, 8%, 22%)' 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)
Anonymous
21 answers
**Reminder** Azure TLS certificate changes
Hello Azure Customers in the community, For users that implement certificate pinning in their application code there are some Azure TLS certificate changes that could impact some of our customers. Microsoft is updating Azure services to use TLS…
asked 2020-10-06T00:42:59.357+00:00
bharathn-msft
5,096
Reputation points Microsoft Employee
commented 2020-11-20T20:39:03.937+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, 49%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQB%3C/text%3E%3C/svg%3E)
Quentin Bracken
6
Reputation points
1 answer
Double registration
Hello, I have registered for the Microsoft Azure Fundamentals virtual training day on the 8th and 9th of december with my private email address instead of the business address. So, now there are 2 registrations for me. Is it possible to cancel the…
asked 2020-11-20T20:05:33.917+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, 83%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Patrick Mans
1
Reputation point
answered 2020-11-20T20:07:11.543+00:00
Anonymous
4 answers
One of the answers was accepted by the question author.
WIndows Server 2019 Standard OEM license for my 48 cores server : Which part numbers to purchase.
I have some doubt in my vendor statement as he told me that it is not possible to buy WIndows Server 2019 Standard OEM license for my 48 core server. Their answer is that there is no option to go beyond 24 core OEM licensing and advise me to go for VL…
asked 2020-05-31T15:01:08.583+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(156.8, 18%, 25%)' 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)
kohler
21
Reputation points
commented 2020-11-20T20:06:33.083+00:00
UMUT DUYUM
1
Reputation point
2 answers
Which license meet the minimum requirement for OOS?
We are running SP2016 and would like to add OOS to our farm. Not sure what kind of license required. According to this blog: https://www.microsoft.com/en-us/microsoft-365/blog/2017/04/18/office-online-server-april-2017-release/ Customers that…
asked 2020-11-18T00:27:26.943+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(281.6, 3%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lui
1
Reputation point
answered 2020-11-20T20:06:21.59+00:00
Trevor Seward
11,706
Reputation points
2 answers
One of the answers was accepted by the question author.
Migrate work items, test cases with links to user stories, history from tfs 2015 to tfs 2017
Hi, Scope of project: We have to migrate the product backlog from TFS 2015 to TFS 2017. This migration includes - Epics, features, user stories, tasks, test cases with links to user stories, and attachments. Current Approach: Using Team Plugin within…
asked 2020-11-20T14:44:28.453+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, 93%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sheekha Khetan
21
Reputation points
accepted 2020-11-20T20:02:08.65+00:00
Sheekha Khetan
21
Reputation points
1 answer
One of the answers was accepted by the question author.
AZURE DATA FACTORY - Oracle Database
Hi , Is it possible to execute Oracle Database Stored Procedure in Azure Data Factory and output as a CSV File? The Stored Procedure tool seems only available for SQL Server Connection.
asked 2020-06-02T09:42:53.087+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, 0%, 27%)' 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)
KnowledgeSeeker
21
Reputation points
commented 2020-11-20T19:48:03.887+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(147.20000000000002, 41%, 24%)' 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)
Chawla, Charu [PHSA]
1
Reputation point
1 answer
How to preview the .msg files using view.officeapps.live.com
We would like to preview some test of documents in a webapp developed using .netcore. QWe can preview xlsx, docx etc. But .msg files are unable to view and showing the result file note found , even those files are in path. Please assist whether its…
asked 2020-11-10T12:39:46.753+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(313.6, 1%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sanchit Jaiswal
1
Reputation point
commented 2020-11-20T19:45:18.04+00:00
Trevor Seward
11,706
Reputation points
1 answer
One of the answers was accepted by the question author.
SSRS Pivot Style Table
I have a matrix that is structured like the image below. My current and expected outputs are provided below. I am wondering what the easiest way would be to build a table like the expected output. My initial thought was to build…
![](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, 49%, 12%)' 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)
2 answers
Render private files on browser applications with office for web look and feel?
I need a functionality, in which I can render office documents on browser applications lwith the look and feel of Office live apps( when used with iframe). My files will be stored on my local server and while rendering I want the office.live look and…
asked 2020-11-19T04:47:13.663+00:00
Sanchit Jaiswal
1
Reputation point
answered 2020-11-20T19:40:31.003+00:00
Trevor Seward
11,706
Reputation points
0 answers
Data Factory copy activity writes a huge file from a tiny file : throttling error ?
Hello, A copy activity has written very large files (over 1TB) when the files should have been tiny (less than 1MB). Here are the details : The activity copy has an SFTP source, binary, and ADLS Gen 2 sink, binary as well. The files have a…
asked 2020-11-12T12:16:26.03+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, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Emilien BOUCAUD
21
Reputation points
commented 2020-11-20T19:37:52.27+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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,816
Reputation points Microsoft Employee
1 answer
Can someone please fix the ACI Deploy Github action that is currently broken?
The official GitHub action to deploy to Azure Container instances has been broken for several days now and I can no longer deploy to Azure ACI. The repo is at https://github.com/Azure/aci-deploy The change that broke this action in Github have been…
asked 2020-11-20T08:41:10.88+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, 6%, 14%)' 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)
Joe M
1
Reputation point
commented 2020-11-20T19:22:08.583+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(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT
20,212
Reputation points Microsoft Employee
0 answers
move xml file from shared drive and injest to data lake
Dear Fellows, I need some help with Microsoft azure, I have a file keep coming in shared folder, as soon as the file lands in shared folder it needs to be moved to data lake, kindly advise how can I do it or if there is any tutorial. Regards
asked 2020-11-16T21:24:53.77+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(220.8, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HuuM
46
Reputation points
commented 2020-11-20T19:01:16.413+00:00
Saurabh Sharma
23,816
Reputation points Microsoft Employee
2 answers
Remove vulnerability "Apache Tomcat Default Files" from an AKS container
Need to remove vulnerability "Apache Tomcat Default Files" from an AKS container where we use "tomcat:9-jdk8" base image. Solution to remove it is provided at "https://www.tenable.com/plugins/nessus/12085". Please let…
asked 2020-11-19T12:22:29.573+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, 31%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pratim Das, Partha C
306
Reputation points
answered 2020-11-20T18:45:03.753+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(249.60000000000002, 98%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
shiva patpi
13,256
Reputation points Microsoft Employee
0 answers
I can't get into Microsoft Authenticator
Trying to download Microsoft Authenticator to use Microsoft Teams and having trouble with iPhone and Apple Mac
asked 2020-11-18T23:59:41.92+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(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vicki Brous
1
Reputation point
commented 2020-11-20T18:42:46.59+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,461
Reputation points
1 answer
Authorize App Service With Two Separate Azure Accounts
I currently have a .Net app service hosted in Azure. I've set this up as a registered app and used openid to authorize users. This works great. I've been tasked with allowing another company to authorize and use the app. This is a subsidiary which…
asked 2020-11-18T14:45:58.707+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, 83%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Ben Meyers
1
Reputation point
commented 2020-11-20T18:28:29.617+00:00
JamesTran-MSFT
36,636
Reputation points Microsoft Employee
2 answers
Errors in Azure AD Sync
The Microsoft Azure AD Sync service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: Restart the service. An error event occurred. EventID: 0xC0001B58 Time…
asked 2020-11-19T05:49:03.297+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, 60%, 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)
Андрей Михалевский
3,331
Reputation points
commented 2020-11-20T18:24:27.34+00:00
AmanpreetSingh-MSFT
56,666
Reputation points
6 answers
One of the answers was accepted by the question author.
SharePoint list dropdownfield autopopulate from external list
Hello, I have a custom list with a textfield autopopulate options. Its working just fine. My client now wants to make it a dropdown. $("#Emp_NameTextBox").autocomplete({ minLength: 2, source: function (request, response) { var restUrl =…
![](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(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES6%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Azure Active Directory
I am working on below scenario I have two accounts in Azure one with Custom Domain in Azure AD. For eg: xyz.com and another account is having abc.onmicrosoft.com. I would like to know if I can deploy Password hash Sync user account from xyz.com to…
asked 2020-11-19T14:02:22.297+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(92.8, 80%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Prashant Nagarkar
21
Reputation points
commented 2020-11-20T17:47:25.38+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,461
Reputation points