How to programally check if the user-assigned managed identity have access/permissions to the key from key vault in an other tenant?
Hi, There is two tenant A, B. tenant A have two application, 1. manageApp used by my program 2. CMEK-app using to get permisstion from tenant B by admin consent. And one user-assigned managed id configured as federated identity with the CMEK-app used…
How to add Auth Headers in REST Linked Service in Azure Data Factory (ADF) when using oAuth2 Client Credentials?
My API provider requires an API-Key additional header when using oAuth2 Client Credential to generate access token. In Azure DataFactory, when I create a REST linked service using OAuth2 Client Credential as authentication type, I also include Auth…
We do not have sufficient capacity for the requested VM size in this zone.
I have had this host pool out there for over a year in the South Central Region and 2 of the 4 hosts are giving me this error this morning. We do not have sufficient capacity for the requested VM size in this zone. these are not new VMSs, they have been…
hii want to run stored procedure in synapse but ima getting an error ,can anyone help me
query: USE gold_db GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS SELECT * FROM OPENROWSET(BULK…
How to use IS NOT NULL in synapse dataflow
I would like to use IS NOT NULL in synapse's dataflow, but I can't get it to work. Can you please tell me how to do it? I have also tried notNull, but it doesn't work... I used the dataflow filter.
Need to compare the data before loading in to sink
Hi friends, I have a requirement that to ensure we load the correct data into to sink Azure SQL database , so want to compare the source data with destination stored data and load only if the data is not exists in sink and store the rejected data in to…
Azure: Fail to verify phone number when adding a new PAYG subscription
attached is the screenshot.
Is it possible to extract sub total in OCR Medical Bill using Invoice Model
The below Image - 1 is the sample OCR Image that I want to extract information. Image - 1 Image - 2 The above image -2 is the extracted information in Items parameter by using prebuilt invoice model . Here I want to extract even subtotals of each…
Azure Firewall & Application Gateway Regional Configuration Clarity
Hello team, Good day!! I have setup Azure Firewall and Application gateway which are 3+ years old now, and during that time, I believe there wasn't an option to choose zones for these two resources and if I check the properties in the JSON of it, I don't…
Export or query for all requests SQL in DW database in Azure Synapse
Hi, I need to analyse the quantity of SQL requests in views of DW database in Azure Synapse. In the tool there is a monitor of SQL requests, but not is possible export the data. There is a table where I can see this data, or other way to consult the…
Functions not available post upgrade to .net8/v4 and deployment through build pipeline
Migrated my project from netcoreapp3.1/v3 to net8.0/v4 using the Upgrade tool. When I publish my local machine, it prompts to upgrade the version to v4 and I am able to see the functions in the function app. But when I use the build pipeline, the…
Error Running Script in Runbook with System Assigned Managed Identity
Hello everyone, I could use some assistance, please. I'm encountering an error when trying to run a script within a runbook. I'm using PowerShell 5.1 with a system-assigned managed identity. The script works find without using the managed identiy via…
Copying complex JSON data dynamically using Mapping Data Flows in Azure
In my current data engineering project, I am tasked with building a pipeline that can efficiently handle various JSON structures. One of the key requirements is the ability to dynamically flatten nested arrays within the JSON data using parameters, and…
Calling Azure function API from Sharepoint classic using Managed identity
We have created an Azure function API in Python which will be further called by SharePoint classic using javascript. We want to make it secure using managed identity. Right now we are providing them API key which we do not want to. Sharepoint is…
Which model version should I be using for my openai deployment
Hi I live in the UK and have written a webapp for a client in Holland. It uses GPT-4 and GPT-3 and have set up the appropriate deployments for both. I need to send the largest number of tokens as possible as the app is summarising data. Something…
Can Daily monthToDate report contain invoiceId?
Hello, If the billing period ends on 3th of the month and the invoice is ready on 12th of the month, will the Daily MonthToDate report return the invoiceId for the records 1st-3th of the month, when it is executed after the 12th of the month?
Error with SAP CDC connector in Azure Data Factory Pipeline
I'm trying to use the SAP CDC connector to load incrementally my SAP data on VBAK and VBAP CDS views. It is weird because It works one time over two. And the other time it crashes with this error : Job failed due to reason: at Source 'SAPSource':…
How does resiliance work with Azure active/active gateway?
Hi, I'm trying to understand how the resiliance works when we have a single VPN on a Azure VPN Gateway running in active/active mode. Our existing Azure zone-redundant VPN gateway has mulitple active/active VPNs already running on it, but I need to…
PVA Chabot with Azure Language Studio
I built a chatbot with PVA and connected it to azure language studio custom question and answering to manage the knowledge base - a simple excel document with question and answer columns and about 150 rows. I've a few had cases of it not being able to…
how to fix missing metricCounters.json for Azure Monitor Agent on Ubuntu 22.04
I have set up a virtual machine (ubuntu 22.04) and Azure Monitor data collection rule, but the performance graphs are not showing. According to the output of Azure Monitor Agent Troubleshooter, metricCounters.json is missing. How can I fix this? ERROR…