Content
How to connect salesforce from azure data factory using OAUTH2
How to connect salesforce from azure data factory using OAUTH2. SSO enabled at salesforce side and also used to connect salesforce from azure data factory using username and password. Now we are advised to use OAUTH in order to connect to salesforce…


How to deploy Docker Hub Linux image to Azure Function? Portal for Function already shows my Docker Image!
I have used visual studio to deploy my compiled C# azure function to dockerhub. I did not see any errors in the visual studio output. I logged into docker hub to confirm that it has been pushed: Yes there is a new image there. Then I use a bash…


I keep hitting "Storage creation failed" when trying to start up cloud shell for azure learning
As part of the Azure learning exercise below, I'm trying to start up my powershell in order to run the shell commands. Exercise - Create an Azure Virtual Machine However, when I try starting up the powershell, it shows the following error: Storage…


Lift and Shift SSIS Packages (on Prim database and external connector) to ADF
We created a simple SSIS package copying data from SQL server (On Prim) to Dynamics 356 Finance and operations using Kingswaysoft Dynamics 365 third party connector. Source - On Prim SQL Server Database Connector - Kingswaysoft Dynamics 365…


Upsert failing in Dataflow
I am reading data from multiple json files and loading them into a sql database. There are duplicates in the json files, but in the dataflow i have explicitly selected upsert. yet this fails at the id. What am i missing ? The ID in the DB is set as…


Is there a way to do an API call from Microsoft Purview to Databricks Unity Catalog?
As part of our project, we are using MS Purview with Databricks. I want to know if there is a way to do an API call from Purview to Databricks Unity Catalog and get data lineage.


I'm in europe, is there a way to get access to GPT-4
Hi there, I applied for the waitlist but saw in this post that it's only available in East US and South-Central US. Will this affect my waitlist position if I'm from Europe? If so, is there a way to modify my application to get access to these…
Why are my fundamental certifications not appearing?
I completed the SC-900 & AZ-900 fundamentals last year but it's not showing up in the reporting; Required Training Dashboard. My account seems to have been unconnected from my certification profile too. Could there by any possible reason why this is…


How to skip wait in "Rerun from specific activity" in ADF?
In the official documents, it mentioned that some activities such as Wait/Until would not be skipped in rerun. Is there any workaround? How to implement a specific activities similar as wait/sleep and could be skipped in rerun, or how could we…


Execute python code through azure function app in vscode
Hi, I have a pyspark code (casings.py) that calls a REST API does pagination and generates output in blob container in the form of delta parquet. I can execute this in a notebook and it runs fine generating output. I need to execute the same code using a…


Virtual Machine Windows 11 for DEV/TEST
Hi I have created a Virtual Machine with windows 11 Pro. I intend to use this for DEV / Test working with VS Code and Power BI and Azure. Do I need to purchase a seperate Windows 11 license for this? It is working up and running, so I can use…


abfss error on Azure Synapse
I'm leaving an inquiry because the error continues when I use abfsss. AttributeError: module 'fsspec_wrapper' has no attribute 'AzureBlobFileSystem' I checked the route, and there was nothing wrong with all of them. also I tried abfs and tried other…


I need to sync Hub database to on-prem SQL express using Data Sync 2.0 agent but no tables are showing for both.
I'm trying to sync the Azure SQL database to the on-prem member SQL express and all the necessary configurations (details below) are all configured and setup, but when I select either the Hub database or the on-prem member database, refresh the schema…


Column Level Lineage with Azure Synapse and Power BI
Hi Team, IS there a way to track column level lineage in Synapse DB? And in Power BI. I cannot see the details of column level lineage in both the sources i.e Synapse and Power BI. Please confirm Any recommendation or alternative approach


How to backup Custom VM Servers with SQL installed, Where do I backup the Database, What should be the strategy
How to backup Custom VM Servers with SQL installed, Where do I backup the Database, What should be the strategy


Azure Open AI - Curie Fine Tune Model Deployment Failed
Hi, I am not able to deploy Azure OpenAI fine-tuned model. Always its failing. I am using Curie as base model and region is West Europe. There are not enough information regarding the error. Initially I have created Azure OpenAI resource in EastUS region…


Can we create dashboard report in Azure Synapse Analytics by without linking to Power BI workspace
I want to create the report for the data in Azure table storage. I could link the azure table storage account and able to linked the data set in Azure Synapse workspace and in preview i am able to see records from the table storage of the selected…


Azure Data Factory: Insert and Update based on source and target columns
Looking for a way in Azure Data Factory to insert(if ID not present in target DB) and update(if UpdatedOn date time of Target db colum is < UpdatedOn date time of Source db column) data from source to target/sink using data flow Source DB ID name…


How to add cookie header in ADF copy activity?
I am working with a SOAP API that uses cookies to authenticate calls. By calling the "Connect" endpoint in a Web Activity I am able to obtain the cookie and using Set-Variable I am able to use that cookie in a subsequent Copy Activity. Here is…


The blob trigger in azure function doesn't trigger every time
Hello, The azure function is consumtion based. We have a customer that is using WinSCP and sftp to write an xml file in the blob container. The customer write the xml file about every 30 minutes. The problem is that the azure function doesn't react…

