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,373 questions
Error in integration between Dataverse and Azure SQL via Azure Synapse link
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
CHARAN TEJA NALLURI
6
Reputation points
Hi,
while using a template in Synapse-related Copy data from Dataverse to Azure SQL, after removing filters in data flow it was creating a previous older record other than a new one.
if I have not removed filters in data flows running successfully but data not moving here there is no issue in data types on both dataverse and SQL end.
please help me to resolve both issues
Azure Synapse Analytics
{count} votes
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator2023-04-04T10:46:42.6133333+00:00 Hi CHARAN TEJA NALLURI, Thank you for posting query in Microsoft Q&A Platform. Could you please share which template you are using here? If possible share steps with screenshots to understand better. Why you are removing
filter transformationhere? Usually template will have all set up done already. they should work fine. Kindly try to enable to debug mode and try to see under each transformation you are able to seeData previewor not. IfData previewis there then it should work accordingly. Kindly share above requested details along with screenshots to understand issue better. -
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2023-04-11T16:49:11.3233333+00:00 Hi CHARAN TEJA NALLURI, Just checking if you get time to share updates. Thank you.
-
CHARAN TEJA NALLURI 6 Reputation points
2023-04-14T12:12:04.58+00:00 Hi ShaikMaheer-MSFT, apologies for the delayed response. please find the following steps below
If I am using Upsert if: my requirement needs audit rows .while using this it will update records for every run means audit rows are not possible. I know the update If option is available but I didn't find any logic. state code will decide the weather record is active or inactive in dataverse table.
Now I am using this flow(running successfully every time): while creating new records other than that It will create previous(last run) rows records in the table in Azure SQL. delete functionality not working. Please help me to find a solution based on the above errors. imported from Gallery:
Sign in to comment
Sign in to answer