Azure synapse analytics running manual notebook is taking less time and when running with pipeline it's taking more time.
Why does my Azure Synapse notebook run much faster manually, but becomes slow and inconsistent when executed through a Synapse pipeline (especially with parallel notebook execution)? I am using Azure Synapse Analytics with a dedicated Spark pool. When I…
Azure Synapse Analytics
Timestamp difference between what's seen in D365 and what I retrieve in Databricks
Hello ! Sorry for the tags I didn't find the appropriate one My company has D365 F&O. We use Azure Synapse Link to put D365 data into parquet files in a storage account so we can use it in Databricks. Nothing weird I am on France time zone. I know…
Azure Synapse Analytics
Cannot use managed identity to connect to service bus
I am trying to connect to Service Bus from Azure synapse using managed identity but it is not letting me to. I need this so that I can disable local auth in Service Bus. Is it possible to connect to service bus from Synapse with local auth disabled in…
Azure Synapse Analytics
Synapse Dedicated pool Scalling up issue
Hi There, We scaled our Synapse Dedicated pool from 300 DWU's to 400 DWU's this morning and its been 6 hours since the request and nothing is happening...
Azure Synapse Analytics
Why does this page pop up when running the SQL script?
After clicking "Cancel", when you try to query again, the same page still appears.
Azure Synapse Analytics
Can I use the same VM for On-prem-gateway and Self-hosted IR for Synapse?
Hello , I have a solution which extracts data from oracle db on OCI and store in data lake. Then use Synapse pipilines and Data flows to process the data and store them in sql db. I use self-hosted IR to extract data from Oracle. I have another solution…
Azure Synapse Analytics
Can't create Azure Synapse link to Dataverse in Power Platform despite having correct apache spark version
I have a dynamics environment in Canada region I have an Azure Synapse Workspace containing a Spark Pool in the Canada East region (there was no 'Canada' option) In Powerapps, I try to create a link to the Dataverse, and after choosing the Azure Synapse…
Azure Synapse Analytics
Synapse notebooks in a workspace don't load BUT are being run by triggers
I have a workspace with all of our colleagues. Platform did a change and it seems that triggers and notebooks are all gone. We cannot access them at all (this has huge business implications for us). We can see the blob storage and the spark pools. When…
Azure Synapse Analytics
How to add extended properties (description) to Tables and Columns in Azure Dedicated SQL Pool?
Is there any possible way to add description to Tables or columns in Azure Dedicated SQL Pool. I tried with sp_addextendedproperty, but I got the error: "PROCEDURE 'sp_addextendedproperty' is not supported."
Azure Synapse Analytics
Automating Table Activation and Deployment for Synapse Link in Dynamics 365 Dataverse
I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to load data into Azure Data Lake Storage (ADLS) Gen2. I seek a solution to automate this activation process and to deploy the same…
Azure Synapse Analytics
how to find azure synapse Vnet/subnet
I am able to find the synapse vnet info by checking synapse IP, but wonder if there is a way to find Vnet info directly by Synapse workspace name? Thanks in advance.
Azure Synapse Analytics
How to fix Cannot read properties of undefined (reading 'valid') error while attempting scaling a Synapse SQL Dedicated pool
Receiving an error message when attempting to scale the Synapse Analytics dedicated pool: Any ideas on how to resolve this? { "shellProps": { "sessionId": "e72684e96bd24d33a7a77f87c774c1cd", "extName":…
Azure Synapse Analytics
I’m experiencing issues loading Netsuite transaction table data into ADLS Gen2 via an ODBC connection in Azure Synapse. What are the recommended troubleshooting steps or configuration changes to fix this?
{ "errorCode": "2200", "message": "Failure happened on 'Source' side. 'Type=System.InvalidOperationException,Message=The connection has been…
Azure Synapse Analytics
Which is the best option for data warehouse / Power BI solution?
Hello, I am building a data warehouse in Azure from several external data sources. Data can be imported via pipelines in Data Factory (or Azure Synapse). Data is to be stored in Azure. Reporting through Power BI is required. There seem to be a…
Azure Analysis Services
Azure Synapse Analytics
Trouble connecting from synapse notebook to eventhub using managed identity
I am trying to write to eventhub from synapse notebook using managed identity but hitting an error. I have enabled the session to use and have managed identity as well. Code Error: com.azure.identity.CredentialUnavailableException: Managed Identity…
Azure Synapse Analytics
Issues with Synapse Workflows After Auto-Update of Self-Hosted Integration Runtime to 5.55.9315.1 (Salesforce V2 Empty-Result Parquet Schema Regression)
Description After our Self-Hosted Integration Runtime (SHIR) auto-updated to v5.55.9315.1 on November 15, 2025, Synapse pipelines that use the Salesforce V2 connector began producing Parquet files with an incomplete schema when an incremental load…
Azure Synapse Analytics
How can I connect a Fabric Trial to Dataverse?
I am trying to connect Dataverse to Azure Synapse Analytics in a Fabric Trial. The Power Apps wizard asks for Subscription ID and Resource Group. The problem is that the Fabric trial does not appear in my list of Azure Subscriptions. (I have the Global…
Azure Synapse Analytics
Terraform setup to collect container logs in analytics workspace
Hello, I've got a small PoC setup involving: An AKS cluster A Log Analytics workspace A data collection rule linking the AKS cluster to the log analytics workspace When I deploy a demo namespace (the contoso pet shop) the application works, but none…
Azure Synapse Analytics
Please help me restore a deleted deployment
I mistakenly deleted some deployments that were in a failed state, not knowing that these failed deployments basically deleted everything in my dev environment. I have lost all our data extraction pipelines, linked services, almost everything. From what…
Azure Synapse Analytics
Does ANALYZE TABLE work with Spark 3.5 and are statistics exposed to AQE?
I am running a notebook in a Spark 3.5 cluster in which I am basically using MERGE to incrementally add to my delta tables. While I was monitoring my spark log execution, I noticed messages like this: 2025-11-24 08:36:36,924 INFO…