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
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
Solved! Go to Solution.
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?
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.
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.
Hey,
Not sure but I am not getting any parameterization option and allowing only from drop down :
Hi NandanHegde,
The last one option allows you to use dynamic content
Thanks.
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.
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
User | Count |
---|---|
6 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
10 | |
7 | |
7 | |
6 |