In last column click on the double arrow in header and confirm. What if we want to consolidate those files into one file quickly. Click on Combine & Transform Data; Select the Excel file which you would like to use as a Sample File for Power BI to automatically create a structure for; Select the Parameter1 folder and not the sheet, Note: Unless you explicitly would like to use a specific sheet in all excel files, do not select the sheet by name. Select File and then select Folder and click Connect. In the Folder window click Browse… navigate to the folder, then click OK. The Power Query Editor window opens. On the Extension column filter to only include the .xlsx files. Folder of Files Loaded to Power BI Desktop Learn how to combine files from #Shar. After you've … Usually you click on Shared Documents table, then down to the folder you want. But this query only makes the list of files, which … Append Queries As New: Creates new table . We want to apply number of similar steps to each files and loop through them and fetch the data all into single data set. Select Data > Get Data> From File>From Folder. Confirm and new query is created. Power Query an … This is the best way when all files are in one folder. One caveat - if you navigate down to the wrong folder there is no way to go back up without manually editing the M code. From there you can transform an entire folder. - open a blank query and paste my code - name the query like fnReadTXT - Read from your folder with the text-files and add a custom column with this formula: fnReadTXT ( [Content]). In an extra-probably-unnecessary step will will see the content of the selected folder. combine multiple files from folder power query next step in order to combine files, we need to select content (first column) and select the data and click ok. combine multiple files from folder power query after that, we will just give some meaningful names to our sheet data as … In Power BI Desktop go to Get Data, select folder and find the folder with files. Confirm and new query is created. But this query only makes the list of files, which isn´t what we need - since we need the data. Click on Combine / Combine & Edit. Paste the path of the folder and click ok After clicking on ‘Ok’ you will see what is located in this folder.