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

Hi, thanks, I bumped into those triggers for blob storage events but was not sure if that could be used in the scenario in which we drop csv files on a specific location. 

Should you then first drop the csv file in a blob container before such a trigger can be used?

thanks