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
when you connect to an Excel file usually 3 steps are generated in PowerQuery:
Source
Navigation
Changed Type
if you go to Source you should see the list of all sheets & named ranges in the file. Navigation drills down to single sheet - instead of that you can filter the sheets you need and expand them as tables - assuming they have the same layout. If they don't then it can still merged them but the structure may be very chaotic