How to bulk insert CSV from Azure Blob to Azure Sql using Azure Function v2 (python)
I have the following code below that inserts one line into an azure sql DB. How would I modify this code to bulk insert from Azure Blob (csvs) to Azure Sql using Azure Function v2 (python)? import azure.functions as func import logging from…
Azure Function 4 deployment fails with "Encountered an error (BadGateway) from host runtime."
A few days ago, I started getting the infamous "BadGateway" errors when I attempted to deploy a new version of my Azure Function. Yes, it is the dreaded "Syncing Triggers" issue...(debug log below) This was working before, I made…
ARM template deployment resets tags for function app
I first deployed an Azure function app using ARM templates, the ARM template includes a couple of tags as well. Now I want to add new app-settings to the Function-App, Adding those through ARM template deployment is causing my 'Tags' to be deleted, Need…
Unable to deploy Azure Function (VSCode) with "arcgis" (latest) python package
Hi I try to deploy an Azure Function App through VSCode. The deployment takes more than half an hour and never succeeds when in my requirements.txt the python package "arcgis" is listed. At least the arcgis latest version does not work for…
Azure Function App Erro
Hi Everyone, I am currently working as a newcomer in the realm of Azure Digital Twins. I am reaching out to seek your expertise on a particular issue I've encountered. In my current project, I am utilizing TwinCAT3 to establish connectivity with Azure…
Function disappearing from Azure Function App
Hi , Im using azure function app triggered by service bus and coding with Python. when I adding the following line : from azure.storage.blob import BlobServiceClient The function disappearing from Azure Function App. I added azure.storage.blob to…
Azure Static Web App function API refusing connection from web app
I have a Blazor WASM app deployed to an Azure Static Web app with a managed .NET 8 isolated Azure Function API. When calling the API directly from Postman using the auto-generated web app URL + the API route I receive the expected response and can see a…
how can I run PySpark in an Azure Function App?
Hi. I'm struggling to run pyspark in an Azure Function App. It returns me Java Runtime error. Is there a way to set Az Function App configuration to run PySpark?
Azure Function Python V2 with bindings to Azure SQL Database
I'm using Azure Functions V2 (Python 3.11). Here you can read that V2 replaces the function.json file with function decorators:…
Enabling 'Outbound internet traffic' feature is not taking effect in FunctionApp - VNet integration.
Hi, We have a number of Web and Function Apps which are VNet Integrated. The subnets associated with each of these Web/Function Apps have Route Table and NSG configured. We have a central Azure Firewall which is configured to handle all outbound internet…
How to fix Microsoft.Azure.WebJobs.Host.FunctionInvocationException on a windows function app?
I have a durable function app running in Azure that works on Linux but throws an exception when ran on Windows. The exception is a Microsoft.Azure.WebJobs.Host.FunctionInvocationException with this error: System.InvalidCastException: Unable to cast…
Where to store SMTP server name and other arbitrary info in Production on Azure?
My task: Make web apps to process or create Excel spreadsheets from database data. The production environment will be on the Microsoft Azure ecosystem somewhere. We don't know which tool to use quite yet. I'm still doing research on which tool is the…
Why azure function consumes more RAM after scaling up App Service Plan?
Hello! I have App Service Plan for my Function Apps with 14 function apps in it. App Service Plan is Elastic Premium 1 with 3.5 GB RAM. During usage of EP1 each function app consumes ~140 Mb of RAM so I decided to scale up from EP1 to EP2. After…
How to optimize amount of data sent via LogsIngestionClient.upload operation
Hi, I am using logs ingestion client in python to upload data. My usecase is to read messages off of aws sqs and build payloads that can be sent via LogsIngestionClient client. I built a simple timer trigger function app that reads aws sqs for new…
Getting 502 Bad Gateway intermittently for Azure Functions in North Europe the last 2 weeks
Since about 2 weeks we are getting intermittent 502's from two of our Azure Functions. We are unable to track it to any code changes (one service hasn't been re-deployed in over a month). To mitigate we have tried restarting and re-deploying one of the…
How to write APIM (Azure API Mgt Svc) Policy to implement RBAC (Role Based Access Control) to restrict access to my Azure Func?
I want to create service two principals using "az ad sp create-for-rbac" and assign custom roles to them using "az role definition create" and "az role assignment create". Then I want to log in as each service principal…
Migrate Function App from In process to Isolated process
I'm trying to migrate my functions from in process to isolated process. Previously we used to configure service bus options in the startup like this : services.Configure<ServiceBusOptions>(options => { options.MaxConcurrentCalls = 100; …
Using Microsoft Document Intelligence along with Azure Function Blob Trigger
Hi, I want to use a blob trigger with Microsoft's Document Intelligence. What should be the remaining code to analyze multiple documents I have stored in my blob storage container? Additionally, I also want the script to trigger any time I upload a new…
Azure APIM | Connection issues
Hi I have an APIM with backends created. These backends point to an Azure Function App. I am receiving frequent logs like The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. A connection…
Azure Logic App Functions runtime error
I have setup my Azure Logic App - Standard Workflow and successfully setup the workflows and have multiple successful runs. But suddenly, it throws an error "System.Private.CoreLib: The user name or password is incorrect. :…