Forum Discussion

dimsandfacts's avatar
dimsandfacts
Regular Visitor
1 year ago
Solved

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

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  

4 Replies

  • 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/4086654

     

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

     

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

     

  • v-csrikanth's avatar
    v-csrikanth
    Community Support

    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

  • v-csrikanth's avatar
    v-csrikanth
    Community Support

    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's avatar
    v-csrikanth
    Community Support

    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.