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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Cyriackpazhe
Helper III
Helper III

get data from folder

Screenshot (36).pngScreenshot (37).pngScreenshot (38).pngScreenshot (39).png

 

Heyy, Had a small doubt. I'm trying to get data from a folder. The folder has two excel documents. 
1. What will happen if i click parameter and opt tranform.
2. There are several tables in the documents. If i click a table and press okay will only that table get combined. What about the other tables?
3. What are the purpose of the four queries that get created? could you explain the purpose of each.
4. Finally, when i load, it only the combined version of that table i selected is there in the model. What should i do to get the other tables.

1 ACCEPTED SOLUTION
Omid_Motamedise
Super User
Super User

Hi @Cyriackpazhe 

1- Clicking "Parameter" & "Transform"

If you click "Parameter", Power Query lets you filter the folder dynamically using a parameter.
If you click "Transform", it opens the folder contents in Power Query for further modifications before combining.


2- Selecting a Table & Pressing OK

Yes, only that specific table from all files will be combined.
Other tables from the files will be ignored unless explicitly selected and processed.

 

3- Purpose of the Four Queries

Transform Sample File – Defines how each file should be processed.
Sample File – Holds a single file's data for transformation reference.
Parameter (if applicable) – Used for filtering.
Final Query – The actual combined table loaded into Power BI.

 

4-Loading Other Tables

To get other tables, repeat the process:
Go to "Get Data" > Folder
Transform the data
Choose a different table inside Power Query
Load it separately

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

View solution in original post

3 REPLIES 3
Cyriackpazhe
Helper III
Helper III

@Omid_Motamedise @lbendlin Thanks for the valuable response

Omid_Motamedise
Super User
Super User

Hi @Cyriackpazhe 

1- Clicking "Parameter" & "Transform"

If you click "Parameter", Power Query lets you filter the folder dynamically using a parameter.
If you click "Transform", it opens the folder contents in Power Query for further modifications before combining.


2- Selecting a Table & Pressing OK

Yes, only that specific table from all files will be combined.
Other tables from the files will be ignored unless explicitly selected and processed.

 

3- Purpose of the Four Queries

Transform Sample File – Defines how each file should be processed.
Sample File – Holds a single file's data for transformation reference.
Parameter (if applicable) – Used for filtering.
Final Query – The actual combined table loaded into Power BI.

 

4-Loading Other Tables

To get other tables, repeat the process:
Go to "Get Data" > Folder
Transform the data
Choose a different table inside Power Query
Load it separately

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h
lbendlin
Super User
Super User

1. You will be taken to the Power Query Editor

2. yes, only the selected tables

3. Did you click the "Combine binaries"  button?

4. Repeat the steps for the other sheets.

 

Ideally you would instead hand craft the code, iterating through all Excel files in that folder and for each Excel file iterating through all sheets. Much more efficient.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.