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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors