5,518 questions with Azure Synapse Analytics tags

Sort by: Updated
0 answers

ReachedPerSubscriptionWorkspaceLimit

When I create a synapse workspace, I have this error: {  "code": "DeploymentFailed",  "target":…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-04T20:15:13.7033333+00:00
Julien Bernier-Haineault 0 Reputation points
commented 2025-11-12T21:26:11.2166667+00:00
Swapnesh Panchal 845 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Access Control in Synapse Dedicated SQL Pool and Impact of Notebooks

Hello, I am looking for some critical information related to data security aspect within the Synapse. Below is our current scenario, We have a Synapse dedicated sql pool in the production environment. The dedicated sql pool has multiple schemas of which…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-11T23:18:08.97+00:00
Parameswaran Serussery Narayanan 75 Reputation points
edited the question 2025-11-12T15:56:36.74+00:00
Parameswaran Serussery Narayanan 75 Reputation points
3 answers

Intermittent Spark Pool Failures and Increased Startup Time After Upgrading to Spark 3.5 in Azure Synapse

We recently upgraded our Synapse Spark pools from version 3.4 to 3.5. As part of the upgrade process, we followed these steps: Removed custom packages from the pools Upgraded the Spark pool version to 3.5 Re-attached the required packages After the…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-09-22T10:41:50.43+00:00
Nikhil Singh 50 Reputation points
answered 2025-11-12T09:57:09.35+00:00
Nikhil Singh 50 Reputation points
2 answers

Unable to Create Synapse Workspace Due to SQL Server Provisioning Restriction

Description: I am trying to create an Azure Synapse Analytics workspace in my subscription: Subscription ID: <<Removing due to security compliance>> Resource Group: <<Removing due to security compliance>> Region Attempted:…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-06T10:50:57.2+00:00
huzaifa khan 0 Reputation points
edited an answer 2025-11-12T06:58:38.4166667+00:00
Pratyush Vashistha 4,650 Reputation points Microsoft External Staff Moderator
3 answers

Error when deploying Synapse

I keep getting the below error when trying to deploy Synapse in Azure. I have tried to change regions and I have unregistered and re-registered services multiple times.. Please help Location 'xxxx' is not accepting creation of new Windows Azure SQL…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-06T20:52:18.8666667+00:00
Mike Fried 0 Reputation points
commented 2025-11-12T06:29:39.07+00:00
VRISHABHANATH PATIL 1,460 Reputation points Microsoft External Staff Moderator
4 answers

Synapse PySpark Notebook issue with Storing Streaming data to ADLS

In Synapse PySpark notebook I am reading data from Event Hub and trying to write/save to ADLS using spark structured streaming as below:- json_schema = StructType([ StructField("id", IntegerType()), StructField("temp",…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-03T13:38:50.13+00:00
Srinivas Challagolla 0 Reputation points
commented 2025-11-12T06:08:14.27+00:00
VRISHABHANATH PATIL 1,460 Reputation points Microsoft External Staff Moderator
2 answers

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-11T12:17:06.86+00:00
Charles Leighton 0 Reputation points
answered 2025-11-12T05:23:47.9166667+00:00
Pratyush Vashistha 4,650 Reputation points Microsoft External Staff Moderator
1 answer

Optimized Apache Spark pools cluster to run parallel notebook in Synapse

I have a cluster(apache spark pool) in azure synapse analytics of the below size With the above cluster configuration when I am using this same cluster in my synapse pipeline to run notebooks I am only able to run 8 notebooks in foreach parallelly. …

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-11T13:36:17.43+00:00
ADITYA SINGH 0 Reputation points
answered 2025-11-12T01:31:21.6933333+00:00
Vinodh247 39,456 Reputation points MVP Volunteer Moderator
1 answer

How to collect information of Users running Insert/Update/Delete Command on the Synapse Pool?

I am looking for a solution which collects information of users who have executed Insert/Update/Delete command on synapse. Tried the Log Analytics Route but the table SynapseSQLPoolRequests only contains Statement type and not Login ID, DMVs store 10,000…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-10T08:45:03.1933333+00:00
Pradyumn Joshi 40 Reputation points
commented 2025-11-11T12:34:06.7666667+00:00
Pilladi Padma Sai Manisha 265 Reputation points Microsoft External Staff Moderator
1 answer

Azure Synapse Link in Power Apps stopped sending new files after Oct 16 – now appending to existing files

We have an Azure Synapse Link configured with a Data Lake in Power Apps.Previously, we received new folders with date and timestamp every hour, each containing fresh data. However, since October 16th, no new timestamped folders have been created.…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-05T15:41:17.4066667+00:00
Devika Dev 25 Reputation points
commented 2025-11-11T06:30:12.6+00:00
Pratyush Vashistha 4,650 Reputation points Microsoft External Staff Moderator
0 answers

How do I monitor a pipeline deployed on Azure Synapse and send email if it fails?

I want to monitor the pipelines that are deployed in Azure Synapse workspace and I want an email if it fails. How do I do this? Logic app doesn't have built-in email notification.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-06T01:06:02.4933333+00:00
Shreyas C S 0 Reputation points Microsoft Employee
commented 2025-11-11T06:26:42.99+00:00
VRISHABHANATH PATIL 1,460 Reputation points Microsoft External Staff Moderator
1 answer

Can only deploy synapse to a single region

I have found that we can only deploy azure synapse to a single region. The Microsoft.Sql resource is registered and we have two synapse resources deployed to centralus already, but cannot deploy to any other region. We are getting the error…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-06T21:59:10.5933333+00:00
elv 0 Reputation points
commented 2025-11-10T18:29:19.54+00:00
elv 0 Reputation points
1 answer

Azure Synapse Copy Activity REST sink HTTP compression is corrupting the payload

I believe there is a bug in azure synapse that is causing the payload to be corrupted on a REST sink with http compression turned on. When http compression is set to GZIP the payload is either empty or corrupt, it's hard to say. Is this a known issue?…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-05T23:42:56.99+00:00
Seth Coleman 51 Reputation points
commented 2025-11-10T16:53:39.8933333+00:00
Smaran Thoomu 32,255 Reputation points Microsoft External Staff Moderator
1 answer

Not able to enumerate SQL Serverless Synapse database from purview

Our purview instance is in a different Subscription (Prod Subscription) and the synapse workspace that we are trying to connect is in a different subscription (Dev Subscription). We followed this documentation and set up all the permissions…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-10-30T14:02:05.25+00:00
Parth Kapadia 0 Reputation points
commented 2025-11-06T18:31:21.2866667+00:00
Smaran Thoomu 32,255 Reputation points Microsoft External Staff Moderator
1 answer

Synapse Serverless SQL pool connection with OPENROWSET to Cosmos DB fails

We have Azure environment with Synapse Analytics that should use Serverless SQL pool to get data from Cosmos DB. Connections are done with private endpoints. And I can see the Cosmos database and container correctly in linked section of Synapse. But if I…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-09-26T12:48:43.1533333+00:00
Kaarlo Räihä 5 Reputation points
commented 2025-11-06T08:16:49.71+00:00
Kaarlo Räihä 5 Reputation points
2 answers

Need to integrate Netsuite with Azure service azure synapse analytics . basically copying the data from netsuite to Azure blob or Azure sql

Need to integrate Netsuite with Azure service azure synapse analytics . basically copying the data from netsuite to Azure blob or Azure sql

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-10-31T11:10:06.4333333+00:00
Suraj Surendran 60 Reputation points
commented 2025-11-05T23:50:57.0933333+00:00
Seth Coleman 51 Reputation points
1 answer

Frequent connection issues to Synapse from Qlik Replicate application after Windows patches in early September

Hi, Our client has an application called Qlik Replicate that writes data to Azure Synapse Analytics which has been functioning fine till a bit over month ago, when Windows patching was applied. The connection to Synapse would drop very frequently at…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-10-29T23:52:13.5066667+00:00
Mohammed Misselmany 0 Reputation points
commented 2025-11-05T22:05:20.7666667+00:00
Mohammed Misselmany 0 Reputation points
1 answer

User gets "Login failed for user '<token-identified principal>'" when creating a DB in Synapse serverless SQL pool, despite having admin roles

Hi everyone, I have an Azure Synapse Analytics workspace, and I’m trying to give another user access to create a database in the Built-in serverless SQL pool. Here’s what I’ve done so far: In the Synapse workspace, under Manage → Security → Access…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-10-23T10:49:18.9866667+00:00
Priyesh Shrestha 0 Reputation points
commented 2025-11-05T17:55:12.8633333+00:00
Abhisek Mishra 940 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to connect dynamics F&O with power bi

Hi , i need to connect dynamics 365 f&o with power bi to analyze data , but i need a better way than ODATA feed as it takes a long time to , how can i achive that ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-11-04T11:37:13.1266667+00:00
Mahmoud Sabry 20 Reputation points
commented 2025-11-04T12:28:56.8266667+00:00
Mahmoud Sabry 20 Reputation points
1 answer

Azure synapse - Issue with quotas increase

Hello, I have a problem with some Azure Synapse Analytics: I currently have 2 Synapse My quota is set to 250 When I try to create another one, I have the following error: Reached the maximum number of Synapse workspaces allowed for this subscription.…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,518 questions
asked 2025-10-27T15:16:22.5266667+00:00
Quentin RODIC 40 Reputation points
answered 2025-11-01T19:53:45.61+00:00
Amira Bedhiafi 40,726 Reputation points Volunteer Moderator