Content
Failed to load one or more resources due to no response.
I am receiving this error message when trying to log into Synapse Analytics "Failed to load one or more resources due to no response."


Can't query partitioned tables - Azure Synapse Link for Dataverse
Hi, we have a problem with accessing partitioned tables in Azure Synapse Workspace that were previously created by ingesting tables from Power Platform via Azure Synapse Link for Dataverse. Snapshot folder and .csv files are normally created but can't be…


Synapse Spark - The access code is invalid
We have some Spark external tables set up to point to a CDM storage folder that is fed by Dynamics F&O. Most of the time, the queries to these tables work but on occasion one or more will fail with below error Operation on target lkupLatestUpdate…


Deadlock Iock
We are facing below error in azure synapse analytics. Any one can help how to track ? ErrorMessage: 110802;An internal DMS error occurred that caused this operation to fail. Details: Please use this Error ID when contacting your Administrator for…


Overcoming 20MB ARM template issue
In reference to the below issue for synapse : https://github.com/MicrosoftDocs/azure-docs/issues/89431 There is a documentation as below : what does this task here mean? Is it the Marketplace add in…


Azure Synapse Spark Notebook : InvalidAbfsRestOperationExceptionjava.net.SocketTimeoutException
I just started working on Azure Synapse Analytics and created a Spark pool. I am trying to run the notebook with the following code:…


Synapse - UserAccounts
On Azure Synapse, We want to control using the workload management by using resource limitations. Can we use something like OAUTH token for multiple teams instead of having multiple accounts to trace the usage and queries?
How to connect serverless sql pool by SSIS?
I want to extract data from serverless sql pool and load into my sql server database table by visual studio SSIS package. I'm using serverless sql pool table as a source and SQL server database table as destination. I can create a OLEDB connection…
Azure Data Factory copy activity stuck on queued status
Hello, I have been experiencing an issue, where the data factory copy activities are stuck in 'queued' status. I have followed the troubleshoot documentation but did not find anything. These are the things that I have checked: Are there old…


How do I delete rows with certain characters in the data flow?
I want to delete this '〇' row in the image in the data flow. Is there a better way to do this?


Please tell me how to retrieve data.
I would like to get the data for the previous 2 weeks from the date specified in the parameter, and I would like to know how to get the data for 2 weeks in one pipeline. The data is stored in GEN2 as AAA/year/mm/day by day. Do I use variables or for each…


Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data
Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…
How do I view the Dedicated pool as a Azure SQL DB
Hi, I have a Stream analytics job. I need to bring one reference input from a Synapse dedicated pool. Can I view or configure the dedicated pool as a Azure SQL DB so that I can bring the data in my ASA job (as the ASA only allows Azure SQL DB). Thanks…


Rename a column name (containing dot in it) of a table
I want to change a column name of a table . But issue is that column name is containing dot in it . which is creating issue while I am executing below statement.:- I can not drop the table as it contains huge and important data expecting Column name =…


How to fix #Could not connect to cluster"
Hi, How can I fix the following issue: Could not connect to cluster Principal 'msauser=ABC@gmail.com' is not authorized to perform operation 'VersionShowCommand' on 'https://XYZ.synapse-ws-haleh.kusto.azuresynapse.net:443/'.…


.NET for Apache spark 3.3
Hi All, We are using C# notebooks for our production workloads. As per link https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime, looks like there is no longer support for .NET on latest spark version. Is there any…


azure subscription
Help me to get more details in subscription as i want to change the address on my profile it's not happeing how do i de.


azure synapse new Link connection error: Failed to enable Synapse Link on the source due to 'The database master key is missing.'.
I am creating a new azure synapse 'Link connection' ... after defining everything including source SQL server ( which lives on NON azure ) and destination Dedicated SQL pool I hit the Start button and get error Failed to enable Synapse Link on the…


how to forcedly restart cluster when notebook activity retry?
Hi I have a synapse pipeline with a notebook activity. Occasionally, the notebook fails. So I change retry option to 2. The notebook does retry when it fails and it runs successfully on the second try. But I find the spark application of first notebook…


How to fix Synapse data flow not updating data in delta lake?
Hi, A dataflow mapping in Synapse writing to a delta sink should update rows based on an Alter row transformation. In the data preview of the debug session I can see that the row should be updated, however after running the pipeline the record is not…

