Get Data from Multiple Excel Files with Different Sheet Names into Power BI

The ability to use Get Data from Folder in Power BI is a very useful option. However, if your sheet names are different in the list of Excel files, then you will face a problem. In this video, I’ll explain a method you can use that works regardless of the sheet names.
Download the sample files from my blog link here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

[CharlesDenecke]

3 days of searching for a solution and found this perfect solution. Thanks.

[ftorresgamez]

Oh, my gosh! This is EXACTLY the solution I was looking for! Excellent tip! Thank you so much!

[muzammelhaquemukul]

Cannot believe this video does not have more view. Thanks a lot for your help.

[MsLegendlime]

I know this is an old video, but it just solved a problem I've been working on for three days. Thank you so much for this content.

[dankoschka]

Dude you are awesome!! I was pulling my hair out trying to figure out how to combine files with different sheet names

[christ]

Exactly what i was looking for, just needed to ask the right question to get to this video. Thanks for the help.

[Swiftmonkey]

EXACTLY what I needed, thank you! Even continues to work when adding future sheets to the connected folder. Appreciated.

[DanielTavares]

Nice video!!! It is so common to have problem whit this..thanks for sharing!
How about when you promote the headers to transforme the data (when you have different names for the files)?

[vikaskothiyal]

This video is an amazing piece of information. Not even "Guy in Cube" can explain with this simplicity and detail.
Thank you so much.
Subscribed to your channel now.

[zzzzzzzaaaaaaaaaaaaaaa]

Hi, how can I import multiple excel files into Power BI without combining the files as the data is all different? The reason is I have 20 excel files. So instead of Get Data > Excel one by one, I want to import one shot.

[Avo_Peach_Corn]

+1 who is struggling w this, and THANK YOU!

[matchanista]

you saved me!!! switching to using the sheet index worked, thank you!

[arunachaleswaran]

In case I can have different number of sheets on each workbook & I need data on all sheets ..?

[LuckyK]

This is what am looking for. Thank you.
in my scenario, folder will also change every day. I wanted to define folder as variable. user is okay enter folder manually every day.

[cika]

Thank you, this video is very helpful. If I created another excel file with the same data format with the existing excel in the folder that has been uploaded in Power BI desktop, would this file automatically be uploaded in Power BI when I refresh it?

[SLeEp]

This worked great for my issue, thanks!

[MandM]

Is there an alternative way? You said index is one option you can choose. My problem is, that the sheets are not always at the same index

[totvabe]

Sorry but I can't see why we put 0 in Source{}. If we don't put 0 is it not posible to combine the files? Thank you

[hippasusofmetapontum]

Thanks so much man! I was stuck at this. Exactly what I needed...

[douglasbrito]

Hi Reza, thanks for this tip, really useful. But in my case I have multiple Excel files and each one has a different number of worksheets to be combined. How I can do that please ? Thanks