Forum Discussion
Solved
Working with multiple excel files as data source
Hi, is there a way to merge all excel files as separate sheets into one file and make a single connect into power bi, currently my queries are connected to single excel file, one query one connection,...
Importing as a folder should work
You can set a file as a data source and then each file in it will be imported into Power BI. When I was using this method I found it didn't work with Excel files, but CSVs worked fine so you may have to do some minor conversion (re-saving as a CSV). As long as they have the same column headings, they should be merged into one large data source.