Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors