When I register for the certification course AZ900 using voucher but unfortunately voucher it show message that voucher is invalid, but voucher expire date is August 2024
I register for the certification course AZ900 using voucher but unfortunately voucher it show message that voucher is invalid, but voucher expire date is August 2024
رقم عجوز روحاني☀️0𝟬𝟗.𝟔𝟔.𝟓𝟳𝟖.𝟑85.770☀️ جلب الحبيب
رقم عجوز روحاني☀️0𝟬𝟗.𝟔𝟔.𝟓𝟳𝟖.𝟑85.770☀️ جلب الحبيب
I can't create a Function with the free subscription
It's been 5 days now trying to create a function app on my free Microsoft Azure account but nothing is working. I have also tried to change regions but nothing is working. Please help me fix the issue.
Error "The DeveloperEmail field is required." when setting up Graph Data Connect
Hello, I'm trying to set up Graph Data Connection using this tutorial: https://github.com/microsoftgraph/dataconnect-solutions/tree/main/solutions/ona/PreRequisites Unfortunately, I cannot finalize the process, because when I click on "Create",…
How to maintain same folder structure as source while sink the processed file
I have a requirement to process the JSON to parquet on daily basis. I have folder A,B,C needs to sink the file to another container with same structure as A,B,C for example if I'm processing a file from folder A it should sink to output container folder…
Unable to load data from Dynamics 365 CRM sales table to MS-SQL
I was trying to load data from Dynamics 365 Sales to MS-SQL using Using Azure Data Factory Copy data tool, Metadata-driven copy task. The type of load I am using is Delta Load/Incremental Load. Facing this issue: Failure happened on 'Source' side.…
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…
Using ADF, how to dynamicaly replace excel headers blank spaces with underscores?
Hello, I'm working on an ADF pipeline whose goal is to copy an Excel file to a blob storage as a parquet file. To do so, I'm using a copy data activity. This activity needs to be as parametrized as possible, meaning that the Excel file schema is not to…
How to refresh table with deadlock?
We Azure postgresql database build. on that we have a ADF process that is doing truncate and load from source schema to prod schema every morning. Teams are querying to prod schema continuously to pull data which causes deadlock on table. then adf…
Create a data factory and pipeline using .NET SDK
Hello, this is my first post here and I hope to find a solution. I am working on a web portal (.NET) hosted in Azure Web Apps and need to create a Service Link for Azure SQL Database in Azure Data Factory when I perform specific actions. The problem is…
Issue with output file format in Azure Data Flow (Delimited text dataset returning parquet files)
I have a Data flow, where I take two sources from a sql database and sink them to a delimited text after some transformation. I am using inline sink types. This data flow works well. After I have another data flow which takes the resulting file and…
In ADF, I am not able to merge data from multiple streams with different columns with different data types
Hello, I am not able to merge data from multiple streams in ADF DATAFLOWS. Stream 1) flow let - only 1 column. Stream 2) flow let - only 1 column. Stream 3) source columns (54 columns) Stream 4) regular…
ADF Lookup activity not returning correct datetime value
A pipeline uses a lookup activity and runs a script against Snowflake, returns first row of data and we are using it in a update statement. Running the lookup to get MAX(load_date) from a snowflake table. In Snowflake it is "2024-04-25 17:26:01.548…
Converting UTC to EST with daylight saving
I am trying to convert UTC to EST with following formula but its not taking daylight saving time to consideration. toString(fromUTC(currentUTC(),'EST'),'yyyyMMddHHmmss') it shows time one hour behind EST. Is there a workaround?
Importing csv file with Json and data with text qualifier and column delimiter
Hi Team, I have a CSV with these details. Text qualifier: " Column delimiter: , Row delimiter: CRLF But as attached, I have 2 columns in csv file, which has json and data with text qualifier and column delimiter. I want to store this file as it…
Cannot edit an existing data factory in synapse
I have a synapse workspace with several pipelines with data factories. Today I have noticed that existing data factories that are running correctly I cannot see the details when I edit them I attach two examples, one that is working and the other that I…
Linked services issue which connecting to OnPrim DB2
I am trying to connect to Linked services for OnPrim DB2 using a VM as middle layer, I have checked the telnet connectivity everything is connected but when I used the selfhosted and tried to connect then I get the attached error, Can any one help to…
Azure Data Factory Old Security->Credential not clear after deploy
Hi, I was testing with the UserAssignedManagedIdentity credential and I created 2 credentials with the same UserAssignedManagedIdentity but different names(UserAssignedManagedIdentity & credentialUAMI). I ran my pipeline to deploy using the dev…
How to translate database content with Azure Translator by ADF or Synapse notebook?
There is an Azure Database table. Some of columns need to be translated from one language to another into additional columns. Such as from English to Spanish, or Portuguese to English, etc. I am exploring how I can use ADF or Synapse notebook to…
ADF dataflow creating temporary folder
Hello everyone, I'm currently generating a file using a data flow, and I've noticed that a temporary file is being created in a directory called _temporary/0/. I have another pipeline that triggers upon the creation of the file mentioned above, and it…