Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Waiting for a database, I am using plenty of CSV files (~1000 files of ~2 MB) stored in a SharePoint repository.
On Power Query to create a table, I use the SharePoint connector, then I combine all files of the repository and then apply data transformations.
I know that SharePoint connector is not the best performant connector but I would like to know how does the combining file process works ? Is Power Query connecting to each CSV files on SharePoint then combine, so it creates ~1000 connections or only one connection to the SharePoint repository ?
Best regards,
Driss
Not sure why this matters to you. But you can use tools like Fiddler to investigate the number of calls being made. At the end of the day your data content has to travel from the folder to your PC's memory. You're looking at many more than 1000 packets.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |