topic Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content in Pipelines

Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

cesarsan7 — Tue, 12 Dec 2023 18:17:24 GMT

Hello,

I'm using Microsoft Fabric and I'm trying to refresh/launch a DataFlowGen2 from the pipeline using Dynamic content, but I'm getting an error. However, when I set the Dataflow name in hard code, the pipeline ran fine.

Error

Please help.

Cesar Sanchez

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

Anonymous — Tue, 12 Dec 2023 19:35:18 GMT

Hi Cesar,

That param is looking for the Object ID, not the text name.

Is there a function to lookup the object ID that you can replace your @variables function with?

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

Anonymous — Tue, 12 Dec 2023 19:48:43 GMT

If you want to test this, export a Dataflow as .json, the Dataflow ID is the second parameter in the metadata (header)

then pass this ID as the parameter.

If you can find a function to look this up dynamically. I can see code in the forum but it's a bit untidy.

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

NandanHegde — Wed, 13 Dec 2023 11:08:26 GMT

Hey,

Not sure but I am not getting any parameterization option and allowing only from drop down :

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

Anonymous — Thu, 14 Dec 2023 16:43:25 GMT

Hi cesarsan7
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

cesarsan7 — Fri, 22 Dec 2023 00:56:08 GMT

Hi NandanHegde,

The last one option allows you to use dynamic content

Thanks.

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

cesarsan7 — Fri, 22 Dec 2023 01:03:27 GMT

Hi richardrann,

Thanks for your reply.

I am using the dataflowId I got from the JSON file and then using this value to start DataFlow Gen2 from Foreach.

Ideally, it could be that the ID could be obtained from the name. Do you know if there is a function that does this?

Thank you

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

Anonymous — Wed, 27 Dec 2023 09:26:20 GMT

I found a post that returns dataflow ID, by querying PowerBI.Dataflows

Solved: Re: Dataflow ID's - How to fetch dataflow Id's usi... - Microsoft Fabric Community

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

DiegoPLAB — Thu, 25 Jan 2024 09:48:27 GMT

Hi richarddrann,

you link refers to Power BI dataflow. I think it's not suitable for Fabric.

Re: Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

DiegoPLAB — Thu, 25 Jan 2024 10:07:06 GMT

Hi everybody,

I understand that using Object ID the problem get solved.

But if you are developing a metadata-driven pipeline, this is not the best solution. Anyhow, getting the Object ID from browser URL or from exported JSON is not very practical. Also, if you remove and recreate the dataflow, you have to get the new Object ID and update it in your metadata.

The possibility of using Object Name in dynamic content would be a helpful feature.