Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cesarsan7
Frequent Visitor

Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

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.

 

cesarsan7_0-1702404433998.png

Error 

cesarsan7_1-1702404629766.png

Please help.

Cesar Sanchez

2 ACCEPTED SOLUTIONS
richardrann
Frequent Visitor

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?

View solution in original post

richardrann
Frequent Visitor

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.

View solution in original post

9 REPLIES 9
DiegoPLAB
Advocate I
Advocate I

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.

NandanHegde
Super User
Super User

Hey,

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

NandanHegde_0-1702465695362.png

 

Hi NandanHegde,

 

The last one option allows you to use dynamic content 

cesarsan7_1-1703206516406.png

Thanks.

 

richardrann
Frequent Visitor

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.

richardrann
Frequent Visitor

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?

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

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

Hi richarddrann,

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

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.