Importing multiple csv files from folder

[Alessandro70]

Hi,

i have a folders with several csv files.

I know how to import them but before i have to import only the first 5 rows of each files and after the rows from 6th to 10th

Can you help me?

Alessandro

[v-priyankata · Accepted solution]

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.

[bhanu_gautam]

@Alessandro70 

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.