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. 

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hi Msoede you should be able to use event triggers in your pipeline to do this.  Please see this video and hopefully this fits with what you need: Microsoft Fabric: Blob Storage Event Triggers in Data Factory Pipelines (youtube.com)

 

----------------------------------------------------------

If my reply has been useful please consider providing

kudos and marking as the solution for others to find

----------------------------------------------------------