How do I add an inbound security rule if there is an default DenyAllInbound Rule that causes an error when attempting to create an inbound rule?
|Received an email with: The public IP address range for the Azure Databricks control plane will be updated on 30 May 2024—you may need to take action You're receiving this email because you use Azure Databricks. To support infrastructure …
How to fix ETIMEDOUT exception in Azure Function appearing out of nowhere?
We use Azure Functions, hosted on Azure App Service to automatically process events. These events are generated and communicated via Azure Service Bus. Without having made any changes, our Azure Function Router is now giving timeout exceptions: Type :…
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…
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…
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.
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…
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…
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…
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 ?
Access APIM through Private Endpoint using public App Gateway
I disabled public access in my APIM and trying to make it publicly available through Application Gateway (with public IP), but I'm getting 403 as requests are originating from a public IP: { "statusCode": 403, "message":…
Azure.AI.OpenAI client: how to re-use existing conversation
We're using the Azure.AI.OpenAI package in our software, which we use with a RAG system to answer questions from our internal information. To support an ongoing conversation, we're saving the conversation to database, and when a user comes back to this…
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…
New azure portal layout?
What's with the awful new layout? Any way to select the old one?
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.
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…
Convert Sql queries to SOQL using ADF
I have an existing adf pipeline which uses lookup activity and get all the table names from azure sql sever. Using for each activity I copy the data from sales force to blog storage. I use dynamic sql queries in copy activity . Select * from…
How to get ACR access token from AAD token using Managed Identity
Hi, I am trying to fetch ACR refresh token using AAD token using managed identity But the oauth2/exchange http call fails with 403 error &{403 Forbidden 403 HTTP/1.1 1 1 map[Connection:[keep-alive] Content-Length:[310]…
Web App Deployment in Azure AI Studio stuck deploying for over a week, how can I cancel it?
I've been deploying a few web apps via Azure AI studio's 'Deploy to Web App' feature within the playground of the 'build your own co-pilot' feature over the last few months, never taken longer than a few minutes, I set one up on Tuesday (16th) last week…
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",…
Upgrade to Premium Azure Firewall SKU
Hi, We are planning on upgrading our standard Azure FW SKU to a premium SKU soon using the upgrade function in the portal. The premium SKU introduces IDPS, I was just curious as to whether that is enabled by default once you upgrade or if it is something…