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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mike9999
Helper I
Helper I

Fabric Data Pipeline -> Parametrize Dataflow gen2 IDs

Has anyone else had success parametrizing a dataflow gen2 in data piplines?

 

When I attempt to give it the workspace ID and the dataflow ID for gen1 it seems to work. BUT when I attempt it with a gen2 dataflow then I get the error:

Refresh Dataflow failed with status: BadRequest, Failure reason: {"error":{"code":"InvalidRequest","message":"Unexpected dataflow error: "}}

 

7 REPLIES 7
GilbertQ
Super User
Super User

Hi @mike9999 

 

Could you please provide some screenshots on how you using the parameterized features in Data Flow Gen 2?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Sure. I was initially starting more complicated with a "Lookup" to get the proper workspace id and dataflow id based on an enviroment parameter.

When that wasn't working I drastically simplified, and put the ids directly to check the basics. 

 

Dataflow gen 1 - works!

mike9999_0-1752631894216.png

Dataflow gen 2 - does NOT work!

mike9999_1-1752632208664.png

Failure type User configuration issue
Details
Refresh Dataflow failed with status: BadRequest, Failure reason: {"error":{"code":"InvalidRequest","message":"Unexpected dataflow error: "}}

Hi @mike9999   ,
Thanks for reaching out to the Microsoft fabric community forum. 

The same setup works with Dataflow Gen1 but fails with Gen2, returning a Bad Request and the message "Unexpected dataflow error"this appears to be a platform-side issue rather than a misconfiguration on your end.

 

It looks like a potential bug or current limitation in Gen2 Dataflow integration with Pipelines. While we await further clarification or updates, I recommend raising a support ticket with Microsoft so the issue can be investigated further.

Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Regards,
Community Support Team

Hi @mike9999 ,

We’d like to follow up on your support ticket. Has the issue been successfully addressed?

If a solution was provided, we’d truly appreciate it if you could share your experience or any relevant details, your input could be valuable to other community members.

 

Thanks again for being an active part of the Microsoft Fabric Community!

Yeah I have a ticket open with the Mindtree support. They got as far as confirming they can reproduce the issue and I haven't heard back since. I haven't heard whether is a known limitation vs bug, etc. I'll update the thread when I know more. 

Hi @mike9999 ,

Thank you for the update! Please do continue to wait for their response hopefully, they'll be able to clarify whether it's a known limitation or a bug. Appreciate you keeping the thread updated.

Thanks for that, it looks like a bug to me as it should work!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.