Forum Discussion
Importing multiple csv files from folder
Hi Alessandro70
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Import the CSV files from the folder:
Go to Home > New Source > Folder.
Select the folder containing your CSV files.
Click Combine > Combine & Load.
Filter the first 5 rows:
In the Power Query Editor, select the table containing the combined data.
Add an Index column by going to Add Column > Index Column > From 1.
Filter the rows where the Index column is less than or equal to 5.
Filter the rows from 6th to 10th:
Duplicate the query with the first 5 rows.
Change the filter to get rows where the Index column is greater than or equal to 6 and less than or equal to 10.