POWER QUERY- help needed- import data from multiple sources with a twist ;)

[AmitM]

Hi everyone,
I have a folder with many identical excel files, each contains data about a different project.
I want to use power query to import 1 specific sheet out of each file existing in the folder (in each excel file- sheet's locations are the same and so are their names).
Here is the tricky part for me-
The sheet has 9 summary rows in the upper part of the sheet that I do not need, and the data table starts from row 10 (header row).
I do not know how to remove these 9 rows, do that to all files and merge the data into a single table.
Appreciate your help!

 

[Matt Allington]

Well if you can wait until my blog post in Thursday at PowerPivotPro - Thoughts on PowerPivot, the future of Excel, and the occasional movie quote PowerPivotPro that should help you.

 

[AmitM]

I can, although if there is a way to get it earlier that will help me to continue the development instead of losing precious days

BTW- PowerPivotPro is AMAZING. I am using it all the time. Thanks for sharing the knowledge!

Matt, with your permission, let me ask you another Q-
do you know of a way too copy/paste multiple DAX formulas between different files? I am building my model all over again (connection issues) and it will take ages to write/copy the formulas one by one

Thank you!

 

[Matt Allington]

Have you been peeking in my Wordpress admin panel? I swear to God this is the exact topic of my post this Thursday on my site. I have already written both of these blogs, but they are not scheduled until Thursday. If you PM me your email address, I will send you a forward view of both posts in the morning my time.

 

[AmitM]

Sent you a PM... THX!

 

[billszysz]

Hi AmitM
I have modified my old example to show you how can we do this.
Of course you have to change folder path.
This is almost UI method.
Hope, this is what you want.
Check link below.
https://drive.google.com/file/d/0B6UlMk8OzUrxWWRMQWJidHBlNlU/view?usp=sharing

Regards

 

[AmitM]

Thank you!

Hi AmitM
I have modified my old example to show you how can we do this.
Of course you have to change folder path.
This is almost UI method.
Hope, this is what you want.
Check link below.
https://drive.google.com/file/d/0B6UlMk8OzUrxWWRMQWJidHBlNlU/view?usp=sharing

Regards

 

[kaiharry12]

In this tutorial, you user Power Query and Query Editor to import data from a local ............