How to pull additional data from source folder, to modifiy a template?

[noah_harburger]

I am trying to modify an inherited Power BI template. the template is set to pull from a designated folder, and pulls a series of worksheets from the excel files in that folder... 

here is the existing Query list:

I want it to pull 2 additional worksheets form the excel files, but when i try to make a new query from the same folder, using the combine and transform option (to be able to select the worksheets i want)...

...it adds parameters and new sample files to the power BI template... 

When i then go to create a new project with the template, it is no longer asking for just a source folder... but for additional parameter values as well - which just messes everything up, and casues the created power BI File to have a bunch of broken data if not defined properly... 

what i want to do is modify the original query - to have it pull additional worksheets from the excel files in the designated folder... i want to avoid any new parameters/source files....  

Is this possible?

[noah_harburger · Accepted solution]

After two days of trying and failing... i stumbled upon this video:
https://www.youtube.com/watch?v=OKoWEhb8Yek

that was able to give me enough direction to make it work... 

Basically - I did NOT need to make any New Queries at all... I just needed to duplicate tables that already existed in the project, and alter the "Applied Steps" to unpack the desired tables from the original source folder. 

[Anonymous]

Hi @noah_harburger ,

Thank you for sharing, please consider marking your reply as a solution, it will increase the weight of the return of later searches for the same problem and will help more people, thanks a lot~

Best Regards,
Gao
Community Support Team