Forum Discussion

Cyriackpazhe's avatar
Cyriackpazhe
Helper III
1 year ago
Solved

get data from folder

  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 seve...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    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

lbendlin's avatar
lbendlin
Super User
1 year ago

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.