How to reset the password of Azure Synapse Dedicated SQL Pool ?
Hello, When I'm creating a linked service to fetch the data from Dedicated SQL Pool within the Azure Synapse Analytics workspace, it ask for the SQL authentication. Since I hadn't created the username and password at that time, I want to create or…
check if the value is a number and output in iif logic of derived transformation
I am checking if the input value is a number then output as '100' else 'invalid' in derived transformation in dataflow. In the documentation, I found 'isLong' function. But, how do we use this function in an iif…
I want to ask wheather you can connect Azure with Power BI in a live connection
If you know a way, an you please explain me how i can do that. I want to create some charts which are live connected power Bi to the working items in Azure. So if a working item changes state, or area etc, it also shows up on the chart as well
Deploying strategy on Lake Database and SQL Database objects to further environments.
I need assistance with deploying the Lake Database and SQL Database objects to the quality and production environments. Despite creating tables and external tables under these databases, I can't seem to find these objects in my branch.
How to ignore the records in ADF Data Flows
Hi All I am building a data transamination using mapping data flows ,I have a time stamp field Like TimeStampUpdated in the target table. I want to lockup historical data with incremental data transamination and ignore the records coming in the…
How to reset password for Azure synapse dedicated SQL Pool "when Reset SQL Admin password" is disabled?
Hello, When I'm creating a linked service to fetch the data from Dedicated SQL Pool within the Azure Synapse Analytics workspace, it ask for the SQL authentication. Since I hadn't created the username and password at that time, I want to create or reset…
How to parse nested json array of document in ADF data flow
Hi all I am trying to fitch the values from a nested josh array of document , I have used aggregate to convert into objects but not able to fitch the values of all child nodes like as below itOffer.item itOffer.item.SplOfr itOffer.item.buy …
The synapse link is not able to write the data in Azure data lake gen 2 storage account
Hi Team, The synapse link is not able to write the data in Azure data lake gen 2 storage account. I am getting the following error message. {"code":"AuthorizationFailed","message":"The client…
We want to create Lake database entity tables using Synapse Industry Database Templates and map from D365 F&O Dataverse tables created using synapse link for Dataverse.
Using Azure synapse link , Table's where created from D365 data. How to create data entity views for the same
SQL Access Strategy
I would like a strategy for the use of Azure SQL with our cloud environment. The DB is in azure SQL. I would like to come up with a solution for giving access to developers and extended/other teams for dev/support needs. WE have to add users and give…
Serverless databases stuck in recovery pending
I'm encountering an issue with two serverless databases in my Azure Synapse Analytics workspace. Since this morning, both databases have been in a "Recovery Pending" state. Unfortunately, I'm unable to influence the recovery process as they are…
Suggested naming convention for Azure Data Factory and Synapse Analytics objects
Hi, I'd like to know if it exists any suggested or official naming conventions about linked services, data sets, pipelines, mapping data flows of Azure Data Factory and Synapse Analytics. F.e., I could use the prefix "ls" for a linked service…
Connectors or replicators available for IBM DB2- AS400 with Microsoft for Synapse
Is Microsoft offering Replicators to copy the data from IBM DB2 to SQL Server or Synapse
Databricks integration to Azure Synapse Serveless SQL Pool
Hi, What is the way to connect to Databricks to Azure Synapse serverless SQL pool when I am trying to connect using serverless SQL endpoint getting an error as - Py4JJavaError: An error occurred while calling o388.load. :…
Azure Synapse database: How to fix HY000 "login failed" error
I'm getting an error when using my Python program to connect to an Azure Synapse MS SQL server. My info: Using Python 3.11 on Windows 10 Pro. And using the pyodbc 5.1.0 module. Server: [blahserver.sql.azuresynapse.net]. This is an Azure Synapse MS SQL…
Complex query performance optimization in Azure Synapse
I am working on a complex ETL process using Azure Synapse Analytics and I need some expert advice on optimizing the performance of a particularly challenging query. I have a large dataset stored in an Azure Synapse dedicated SQL pool. The dataset…
Where are the DataSets for the Prepare and transform data with Azure Synapse Analytics
Hello i am learning via the Microsoft Learning Modulle "Prepare and transform data with Azure Synapse Analytics" and try to reproduce the exercise. But i don't have acces to the datasets and the data sets are also not mentioned in the training…
Azure Synapse Deployment Failure with "Exception has been thrown by the target of an invocation."
0 Failure to deploy azure synapse pipelines with below error: Set-AzSynapsePipeline : Exception has been thrown by the target of an invocation. 2024-05-08T08:29:52.7382260Z [31;1m[31;1m+ … $deploy = Set-AzSynapsePipeline -WorkspaceName $WorkspaceName…
Can't able to connect the VM installed postgresql from ADF
Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…