Forum Discussion

sharathKumar's avatar
sharathKumar
New Member
10 months ago
Solved

Need Help: Making Dataflow Gen2 destination dynamic + syncing updated mashup.pq back to Fabric

Hi everyone,   I’ve built a Dataflow Gen2 pipeline in Fabric that connects to a Salesforce report using report id as the source and writes the data to a SharePoint folder as the destination.   Cu...
workspaces
  • sharathKumar's avatar
    sharathKumar
    9 months ago

    Thank you Vinodh247 for quick response. 

    I am thinking to build a notebook for SharePoint so that i can make it dynamic.

     

v-achippa's avatar
v-achippa
Community Support
9 months ago

Hi sharathKumar,

 

Yes that is correct but currently Dataflow Gen2 does not support fully dynamic SharePoint destinations like (path or filename).

The best way is to write the dataflow output to OneLake (lakehouse or file) and then use a fabric pipeline or notebook to upload or rename the file into SharePoint using runtime parameters.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
9 months ago

Hi @sharathKumar,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa