Feb 19 • Technical
What's the best way to load multiple Excel files, each with multiple sheets, from a SharePoint folder into MS Fabric Warehouse?
I have over 26 Excel files, each named in the format DPI-YYYY-MM-DD (e.g., DPI-2023-01-06, DPI-2023-01-20, DPI-2023-02-03, etc.). Each file contains seven sheets (Sheet 1 to Sheet 7), and I need to load them into a Data Warehouse in MS Fabric. What would be the most efficient and ideal approach to accomplish this? Any suggestions?
2
6 comments
What's the best way to load multiple Excel files, each with multiple sheets, from a SharePoint folder into MS Fabric Warehouse?
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+36
2
+23
3
+19
4
+15
5
+12
Powered by