Json code from synapse analytics into Fabric pipeline

[gk_2024]

I'm trying to replicate the code from Synapse analytics pipeline into Fabric Synapse DE data pipeline. I'm able to edit the json code in Fabric UI but when I try clicking on save it gives a weird error. Also, for copy object nothing appears so as to update connection. Is this possible or I have to create pipeline from scratch? Is there a mount coming soon for Synapse Analytics similar to ADF?

ce/powerbiwfe/extension/dpe/adfwebsite/main.5b447a6cc33d7827.js:1:10693148)\n at s.invoke (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at Y.run (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at s.invokeTask (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at Y.runTask (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at ee (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at invokeTask (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at invoke (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...n at c.args.<computed> (https://content.powerapps.com/resource/powerbiwfe/extension/dpe/adfwebsite/polyfills.d5df908801ebd39...)","message":"Error: Error: Error: TypeError: Cannot read properties of undefined (reading 'toResource')"}

[v-jingzhan-msft · Accepted solution]

Hi @gk_2024 

I guess the data pipeline in Fabric does not support all the activities or properties in the Synapse pipeline, so directly copying the JSON code will result in failure. Additionally, I haven't found documentation that specifies the differences, making it difficult to troubleshoot the JSON code directly. Creating a new one from scratch might be faster and more reliable.

Additionally, you have a legacy "Invoke Pipeline" activity. Which pipeline is this activity calling? There are currently two Invoke Pipeline activities (legacy and preview). The legacy invoke pipeline only supports Fabric pipelines in the same workspace as your parent pipeline. You can also only monitor the parent pipeline and cannot invoke ADF or Synapse pipelines using the legacy activity. Using the new preview invoke pipeline activity will allow you to invoke pipelines across Fabric workspaces, from ADF or Synapse, and monitor child pipelines.There is a current known limitation with the preview activity that prohibits the use of pipeline return values. This issue is being fixed and is temporary. Invoke pipeline activity - Microsoft Fabric | Microsoft Learn

So if you want to call a Synapse pipeline from Fabric directly, you may try the new "Invoke Pipeline (Preview)" activity. 

From this thread, there may be more updates regarding data pipelines in the future, but the specific implementation dates have not yet been officially announced.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[gk_2024]

Thank you, as per the above link you shared looks like there is a longer-term roadmap but with no tentative dates.

"We will provide built-in mechanisms to "mount" your existing pipelines from ADF and Synapse into Fabric workspaces as a way to run your pipelines with data flows as-is. Our longer-term roadmap includes "upgrade" paths to turn those ADF & Synapse pipelines into Fabric native pipelines."

[FabianSchut]

Hi, it is not possible to copy your Azure Synapse Analytics JSON code and paste it into Fabric. They use a different JSON setup. I can't find anything on the roadmap saying that Synapse will have a similar migration tool as ADF currently have. You can regularly check this documentation page and see if it shows up: https://learn.microsoft.com/en-us/fabric/data-factory/upgrade-paths. For now, I would suggest you rebuild your pipelines in Fabric.