cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
julrua
Frequent Visitor

Avoid Helper Queries

Dear all, 

 

I did the following steps for 4 differents folder: 

1- Get data 

2- Folder 

3- Combine data 

 

Can I avoid to have several Helper Queries into Power Query Editor ? 

Thank you in advance. 

Helper Queries.JPG

1 ACCEPTED SOLUTION
Vera_33
Super User
Super User

Hi @julrua 

 

You are reading from folders, right? Add a custom column, then use Excel.Workbook or Csv.Document (or anything else, depending on your files in the folder) to avoid help queries, combine the tables in the custom column

 

Vera_33_0-1617067680285.png

 

 

 

View solution in original post

5 REPLIES 5
Hammerschmidt
Regular Visitor

Hi @Vera_33 

 

I have the same problem, however adding the custom column didn't solve the problem.

 

I leave the folder that I am trying to carry out the queries: https://drive.google.com/drive/u/0/folders/10RNAAKY2IQJbcHzocw58rBHOtNFyqLij

 

Example of what the reading looks like after adding the custom column: 

error.png

 

thank you very much for your attention 🙂

 

edhans
Super User
Super User

Not without 100% manually doing the combine operation yourself with manual code.

 

Those were introduced about 3 years ago to make the combining of files more robust and flexible. There is a full overview here.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Vera_33
Super User
Super User

Hi @julrua 

 

You are reading from folders, right? Add a custom column, then use Excel.Workbook or Csv.Document (or anything else, depending on your files in the folder) to avoid help queries, combine the tables in the custom column

 

Vera_33_0-1617067680285.png

 

 

 

Hi @Vera_33 I had the same problem with @julrua and did your recommended action to no avail. The custom column was showing an error. Is there any other way to solve this? Thanks 🙂

Hi @ronaldbalza2023 

 

what kind of error you came across? what type of files in the folder you wanted to combine? with the same header?

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.