Forum Discussion
get data from folder
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 OKYes, 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
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