Microsoft Power BI 👉👉 How to load multiple Text Files from a Folder ? | Power Query ✨✨
Microsoft Power BI
How to load multiple text files from a folder into Power BI ?
Power Query
Source Microsoft Power BI Documentation
Here's a powerful approach to importing data into Power BI Desktop:
If you have multiple files that have the same schema, combine them into a single logical table.
This popular technique has been made more convenient and more expansive.
To start the process of combining files from the same folder, select Get data, choose File ➡️Folder, and then select Connect.
Enter the folder path, select OK, and then choose Transform data to see the folder's files in Power Query Editor.
The combine files transform then automatically takes these actions:
Creates an example query that performs all the required extraction steps in a single file.
Creates a function query that parameterizes the file/binary input to the exemplar query
The exemplar query and the function query are linked, so that changes to the exemplar query are reflected in the function query.
Applies the function query to the original query with input binaries, such as the Folder query. It applies the function query for binary inputs on each row, then expands the resulting data extraction as top-level columns.