The combine files transform then automatically takes these actions:Ĭreates an example query that performs all the required extraction steps in a single file.Ĭreates a function query that parameterizes the file/binary input to the exemplar query. The transform allows you to select a specific object from the first file, such as an Excel workbook, to extract.The combine files transform analyzes each input file to determine the correct file format to use, such as text, Excel workbook, or JSON file.The combine files transform behaves as follows: Or you can just select the Combine Files icon next to Content. To combine binary files in Power Query Editor, select Content (the first column label) and choose Home > Combine Files.
To start the process of combining files from the same folder, select Get data, choose File > Folder, and then select Connect.Įnter the folder path, select OK, and then choose Transform data to see the folder's files in Power Query Editor. This popular technique has been made more convenient and more expansive. 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.
