Is there a list of error codes and their meaning
Hi, As part of custom audit logs, we want to capture errors in case something fails. We tried with getting message from failed activity, but they can be very long, especially in case Notebook fails. So we wanted to switch to store error code, and have a…
Can't run Azure Fabric Notebook cells in VS Code
Hey, I am trying to get Azure Fabric Notebook to work with VS Code using the Synapse Visual Studio Code Extension as described in: https://learn.microsoft.com/en-us/fabric/data-engineering/setup-vs-code-extension I managed to install the prerequisites,…
How to fix on this error
Started executing query at Line 1 File 'https://datameshpoc.dfs.core.windows.net/datamesh-poc/Loan_Servicing.csv' cannot be opened because it does not exist or it is used by another process. Visit this article to learn more about this error Total…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Unexpected $500 Billing for Azure Synapse
I activated the Azure Synapse service on August 1st using the default settings. However, I noticed that I am being billed $250 per day, which has accumulated to a total of $500 over the last two days. As a student, I am using this service solely for…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Azure synapse Write access to spark pool not working
Hi, I am trying to install a package from azure devops to a synapse spark pool. I am getting an error for my managed identity that it does not have authorization to perform action 'Microsoft.Synapse/workspaces/bigDataPools/write'. The managed identity…
![](https://techprofile.blob.core.windows.net/images/KhnRGP5_AwAAAAAAAAAAAA.png?8DBA61)
How to copy data from oracle on-prem database to Azure Synapse analytics
Currently, I have configured a project in Synapse Analytics. I have the following problem: I have created a linked server that points to an Oracle database in a local environment; however, it does not allow access and returns the following error when I…
Use Self Hosted Integration Runtime in Feature Branch
I have created one Self Hosted Integration Runtime in Synapse Workspace in Collaboration Branch. I want all developers to use that IR in their Feature Branch. I don't want to merge the collaboration branch to feature branch as developer has already done…
Error trying to validate storage account name while creating a new synapse workspace
I am unable to create a new data lake storage (gen2) account name in the basic tab for create Azure Synapse Workspace. The error I get is - " There was an error trying to validate storage account name. please try again ". The error message is…
My python code uses AzureCliCredential() function, but it is giving error in running in Synapse/ADF/Databricks notebook .
My python code uses AzureCliCredential() function, but it is giving error in running in Synapse Workspace that your Azure Cli command not found on path . I have tried using other function like DefaultAzureCredentials(), ClientSecretCredentials () also…
TEMPDB ran out of space during spilling out in Azure Synapse SQL pool
Hi All, we are facing the Issue with TEMPDB full in Synapse SQL Pool. Due to this, our Daily jobs getting failed.# Does anyone come across this issue? Kindly help to clear off TEMPDB space in synapse SQL pool. Thanks in Advance
How to copy D365 data into Azure SQL db
Hello, This is going to be long winded so please bear with me. For the past year I've been extracting data out of D365 using the basic set up of a Synapse Link with incremental folder updates in Power Apps for the dumping of data in a storage account and…
what parameters should be defined for a dataflow activity
Hello Having set up a new pipeline using a previously defined dataset, I am getting an error. I am trying to remove duplication in all tables using code snippet for distinct rows. I am not clear what the parameters should be? Thanks in advance
Disable activity within pipeline in Azure Synapse/Data Factory
We are building a Data Warehouse on Synapse using ETL. We need a way to stop and start activities automatically in case of issues or during deployments, as the current manual disable/enable option is impractical for production. Is there an alternative…
![](https://techprofile.blob.core.windows.net/images/5kfUQwbXfkqnY7o5wQqfdA.png?8DAA55)
How to connect on-prem SQL Server using Synapse Notebook
Hi Team, we have to connect to on-prem SQL Server using synapse notebook we have the below details to connect to it. Server=tcp:N11-xxxxxxxx.com;Initial Catalog=xxxx;User ID=xx;Password=xx we have tried the below syntax it is not working, Could you…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Deployment Managed Private Endpoints for PrivateLink Service via Azure DevOps failing
We have an issue with deploying Managed Private Endpoints (MPEs) for PrivateLink Service from Azure DevOps via Synapse Workspace deployment extension, the deployment task returns following error (shortened/redacted): ##[error]Encountered with…
How to run another Synapse Notebook from one Synapse Notebook
I try to run another Synapse notebook in one Synapse notebook. And I found the documents for using %run or mssparkutils.notebook.run, but both of them failed. when I use %run, I got the error below, but as you can see that the notebook is there. When…
Copying data from DB2 to Azure SQL Database using copy data activity and getting Invalid Parameter Error
"errors": [ { "Code": 11402, "Message": "Failure happened on 'Source' side. ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'index' is…
Synapse sql pool to Fabric
We are currently utilizing a Synapse dedicated pool database for our data warehousing needs. We are planning to migrate to Microsoft Fabric to leverage its enhanced capabilities and features. Could you provide detailed guidance on the best approach for…
Synapse Workspace | pandas.read_excel is not working on a new cluster
Hello, I have a new spark pool with spark version of 3.4: I was trying to read excel file via Pandas but got an error: Basically, from the same path I'm able to read CSV file but not able to read excel file what makes me think that it is connected…
How can I use the Range function in the dynamic expression editor of the Data Flow Pagination Rules?
With a Copy Activity pagination rules, you can use a Range function to generate a range of values for the offset like this : "paginationRules": { "AbsoluteUrl.{offset}": "RANGE:0:$.meta.total_count:1000" } But this is…