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,
I want to combine multiple excel files into one database.
Every day I get 1 new excel file in the same format but different data and put it into the same folder.
I used the tutorial on youtube: https://www.youtube.com/watch?v=a7E29H5ZUmE
It's understandable and works with test data but not for my excel files
In this tutorial the first row is the header and that's my problem.
The first 25 rows (red) from each excel file must be deleted.
Row 26 (orange) is the header and after row 26 the data.
I can change this by hand each time but it must be automated (way of working now!).
How can this problem be fixed en delete those 25 first rows from each excel file and combine it into one database.
Kind regards,
Mark
Solved! Go to Solution.
In the Query Editor, Home tab, use the Reduce Rows menu, Remove Rows button to select "Remove Top N Rows". Set it for 25 and it should remove those rows automatically for you when it does the data import.
@Anonymous,
For more complex task, do research into The Advanced Editor.
@Anonymous,
For more complex task, do research into The Advanced Editor.
In the Query Editor, Home tab, use the Reduce Rows menu, Remove Rows button to select "Remove Top N Rows". Set it for 25 and it should remove those rows automatically for you when it does the data import.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |