Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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
Solved! Go to 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
many thanks for your suggestions!
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