What is the firewall port for Microsoft Access connect with Azure Synapse Workspace and Synapse SQL Serverless Pool?
Hi, I am trying to connect Microsoft Access from local desktop to the Cloud Azure Synapse SQL Serverless Pool, and the port 1433 should be the default one for connection. But when we are trying to search for answer from the internet, there're someone…
Azure Synapse Analytics

Azure Synapse pipeline fails with 'invalid_client_id' despite successful test connection
I'm encountering a frustrating issue with my Azure Synapse pipeline. My pipeline fails with an 'invalid_client_id' error when a copy activity attempts to write to a Salesforce sink using Client ID/Secrets during Azure Synapse Salesforce Cloud System…
Azure Synapse Analytics
ADF can not parse Parquet files
I have a pipeline that consist copy data activity like following; I installed OpenJDK on all servers where we use our Integration Runtime. But still, I get error like the following; { "errorCode": "2200", …
Azure Synapse Analytics
Azure Data Factory
Scaling up Synapse Dedicated Pools taking a long time
Scaling up Synapse Dedicated Pools is taking more than an hour
Azure Synapse Analytics
Recommended Step by Step to Rename Azure Synapse Pool
New to Azure Synapse Workspace and pools. DBA's are trying to find a process to restore database from prod into dev. So for example, can set a restore point, can restore. The issue, trying to determine how to rename the pool so that things that rely…
Azure Synapse Analytics

Hot fix create button not finish loading for Dedicated SQL Pool (formerly SQL DW)
Create Button in Dedicated SQL Pool is Stuck on Loading. I have tried also switching internet and trying in incognito mode and still won't work.
Azure Synapse Analytics
Issue with Write-Back to Legacy System via ODBC Connection in Azure synapse
Hi, I'm attempting to perform a write-back operation to a table in a legacy system using an ODBC connection. The DSN is configured in ODBC mode, which supports both read and write operations. We’re able to preview the data successfully using the…
Azure Synapse Analytics
How to connect Azure Synapse with Sharepoint server
How to connect/create Linked Service between Azure Synapse to Sharepoint server
Azure Synapse Analytics
Excel file ingestion failing with error code 21359 in Synapse – file not password protected
We are encountering an issue when trying to connect and preview data from an Excel file (errorapache.xlsx) in Azure Synapse Analytics. The pipeline fails with the following error: Error code: 21359 Details: Encrypted excel file 'errorapache.xlsx' is…
Azure Synapse Analytics
High availability of Synapse dedicated SQL pool within a region
We have provisioned a Synapse dedicated SQL pool for our business. We need to make sure that the service is highly available within the region. This means we cannot have the data be moved to another region but need to make sure that the DWH is available…
Azure Synapse Analytics
How to migrate the data from Teradata to Azure Synapse in batch mode with low network latency
How to migrate the data from Teradata to Azure Synapse in batch mode with low network latency
Azure Synapse Analytics
Azure Synapse Workspace Capacity Error
We were using small sized core setup on our Synapse Analytics and we are trying to process 5GB data and it is taking more time, Hence we trying to maximize the core size , but unable to do so. Can some one help increase quota for us.
Azure Synapse Analytics
Issue with Dynamic List Name in SharePoint to Azure DataLake Synapse Pipeline
Hello, I’m currently working on building a data pipeline to copy SharePoint Online list data into Azure DataLake. The pipeline uses a Lookup activity to retrieve the list names and a Copy activity within a ForEach loop to process each list. The pipeline…
Azure Synapse Analytics


Apache Spark poll ends with time out error
Hi, When runninn my pipeline which contains a Notebook activity, I faced this error. This error appears suddenly sometimes, and sometimes doesn't happend This pipeline executes iteratively almost 15 times, for the same Notebook which is parametrized. The…
Azure Synapse Analytics
How to read a csv file from synapse link service to a storage data lake
I am trying to use pyspark via synapse to read a table/csv file that resides on a storage account. I have got the code below, but 2 things. Its failing due to access and i am not sure if the syntax is correct wither. I have got a synapse spark pool and…
Azure Synapse Analytics
An error occurred during execution: Error: Get workspace location error: Could not fetch access token for Azure. Verify if the Service Principal used is valid and not expired.
Can anybody help this one i was getting this issue : 2025-08-12T05:17:07.7528279Z ##[section]Starting: Synapse: DEPLOY (templates) 2025-08-12T05:17:07.7532471Z…
Azure Synapse Analytics
Data flow / Derived column doesn't see columns names - 'Column not found'
Hello, I am working with Derived Columns in Data Flow within Azure Synapse Analytics for the first time and am encountering some issues. Despite following tutorials and conducting simple tests, I receive an error message stating "Column not…
Azure Synapse Analytics
Azure Data Factory

Error when running debug on a pipeline in synapse
I have got a sink destination for a synapse analytics pipeline, works well with the storage account setup with synapse, however I am trying to change the sink destination to a different storage account, anytime I do that and run the pipeline in debug…
Azure Synapse Analytics
I passed a certification registered under Microsoft account. How can I download the certificate when this account was closed?
Hi, there I passed a certification registered under Microsoft account. I signed in with Microsoft account to book the exam and passed it. Now this account was closed and I can no longer to sign in with it, I don't have access to the certificate. How can…
Azure Synapse Analytics

Azure Synapse API call 403 error when accessing Synapse Notebook with GET method
{ "error": { "code": "Unauthorized", "message": "The principal '71b82c6f-3c4b-4060-a695-61e366d4f5f8' does not have the required Synapse RBAC permission to perform this action. Required…