How to ingest Excel data into fabric table

[Msoede]

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

[Msoede]

many thanks for your suggestions!

[pallavi_r · Accepted solution]

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