Passing Source FilePath Parameter into Fabric Dataflow Gen2 using Power Automate or Fabric Pipeline

[dimsandfacts]

Hi, I have multiple filse in sharepoint online. I have set up a sample dataflow gen2 with parameter inside power query for file location. 

I want change the file location parameter during run time using either Power Automate or Fabric Pipeline. Is that possible ? thanks  

[v-csrikanth]

Hi @dimsandfacts 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply.

[v-csrikanth]

Hi @dimsandfacts 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you,
Cheri Srikanth.

[v-csrikanth]

Hi @dimsandfacts
As highlighted by @nilendraFabric , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Thanks 
Cheri Srikanth

[nilendraFabric · Accepted solution]

Hello @dimsandfacts 

 passing a file path parameter dynamically into a Microsoft Fabric Dataflow Gen2 using Power Automate or Fabric Pipelines is not supported. This limitation has been confirmed in the community discussions as well, and this capability is planned for Q1 2025.

https://community.fabric.microsoft.com/t5/Dataflow/Dynamic-datasources-are-not-supported/td-p/408665...

https://learn.microsoft.com/fi-fi/fabric/release-plan/data-factory

If this answered your question please accept the solution and give kudos.