topic Use dynamic content in Pipelines

Use dynamic content

dibeau — Tue, 24 Sep 2024 13:18:36 GMT

Hi community

I’m trying to add a Dataverse destination as dynamic content, but I’m unsure what value should be used for this. I’m also not certain if this functionality even exists.

In the screenshots below, I’ve successfully added a Lakehouse as dynamic content, which works perfectly. In the second screenshot, you’ll see how it appears when selecting the Dataverse connection (without dynamic content).

Thanks in advance!

Re: Use dynamic content

FabianSchut — Tue, 24 Sep 2024 14:54:18 GMT

Hi dibeau,

At the moment, only Lakehouse, Warehouse and KQL Database are supported in the dynamic content section of the copy activity. You may create different copy activities with other connections and determine which copy activity is run based on a switch statement (I know this is not easy to maintain, but a workaround you could try).

Re: Use dynamic content

Anonymous — Wed, 25 Sep 2024 07:21:36 GMT

Hi dibeau ,

As FabianSchut mentioned, dynamic content is currently only supported for Lakehouse/Data Warehouse/KQL Database object ID.

You can refer to below document:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.