Forum Discussion

Msoede's avatar
Msoede
Frequent Visitor
1 year ago
Solved

How to ingest Excel data into fabric table

Hi, 

 

Before we started working with fabric we used sql server and were able to ingest date from excel files using vba (creating a flat data table and read that to a sql server table).

 

Now using fabric we chose to  place csv files on a sharepoint location which triggers a flow and with that flow we read the data to a fabric table. 

 

I am still curious whether or not there alternatives for getting data from Excel files to fabric tables.

 

Many thanks,

 

Regards, 

 

Michiel

one lake
  • pallavi_r's avatar
    pallavi_r
    1 year ago

    Hi Msoede 

     

    You can choose to  use data flow gen 2 to load incremental data from sharepoint to fabric tables using a data pipeline. Or you can also utilize Data Factory for loading the incremental data, following  a medallion architecture and watermark column for the changed data.

     

    If this post helps, please accept this as a solution. Appreciate your kudos.

    Thanks,

    Pallavi

2 Replies

  • Msoede's avatar
    Msoede
    Frequent Visitor
    1 year ago

    many thanks for your suggestions!

  • pallavi_r's avatar
    pallavi_r
    Icon for Super User rankSuper User
    1 year ago

    Hi Msoede 

     

    You can choose to  use data flow gen 2 to load incremental data from sharepoint to fabric tables using a data pipeline. Or you can also utilize Data Factory for loading the incremental data, following  a medallion architecture and watermark column for the changed data.

     

    If this post helps, please accept this as a solution. Appreciate your kudos.

    Thanks,

    Pallavi