Forum Discussion

Msoede's avatar
Msoede
Frequent Visitor
2 years ago
Solved

Onelake trigger to Ingest CSV

Hi, hopefully somebody could advice me on the following. For a manual process we export a csv file and place it in a folder in our onelake directory in explorer. We have created a pipeline in Fabric ...
data pipeline
data warehouse
  • Msoede's avatar
    Msoede
    2 years ago

    As a solution I created data flow in Fabric to append data to a table in the Onelake and I trigger it via Power Automate "when a file is created" in a specific SharePoint folder. 

Msoede's avatar
Msoede
Frequent Visitor
2 years ago

As a solution I created data flow in Fabric to append data to a table in the Onelake and I trigger it via Power Automate "when a file is created" in a specific SharePoint folder. 

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

Nice, interesting solution!

 

If I understand correctly:

The file is first uploaded to SharePoint, this triggers Power Automate, then Power Automate triggers the Dataflow Gen2, the Dataflow Gen2 connects to the file in SharePoint and writes the content to a Lakehouse table in Fabric.

 

SharePoint -> DFg2 -> Lakehouse Table

 

And the process is orchestrated by Power Automate.

 

How do you trigger a Dataflow Gen2 from Power Automate? (Which connector?)

  • Msoede's avatar
    Msoede
    Frequent Visitor
    2 years ago

    Refresh a dataflow