When you select “Import”, you’ll receive the error “ The key didn’t match any rows in the table.” – this is because the other workbooks don’t contain any sheets with that name (though the error is a bit cryptic).Select an example file and which sheet you’d like to import – this is what you’ll use to create your transformations (before the files are merged together) – in this example, my sheet is called “Bob’s sheet” (which is specific to just that single file).Select the folder where your files are stored (I have three files in the folder in this example).Select “Get Data” -> “From File” -> “From Folder” – this lets you import all the files from a folder at once (assuming their format matches).The problem was that each workbook had a different name for the first tab and the import process gets data from tabs with the same name (assuming all your files match).īy default when you create a workbook, Excel names the first sheet “Sheet1”, but if the files you’re importing have sheets with different names, you can tell Power Query to load the first sheet of each file, regardless of the name – here’s the process (skip to step 5 to see the specific M-query solution): I recently had to import a large number of Excel workbooks into Power Query ( using “From Folder” – if you haven’t used this feature, it’s a huge time-saver when you’ve got a ton of matching files to import).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |