When importing many identical Excel files from a folder into power bi, how to select many tables?

[mgbsher]

Hi,

When importing many identical Excel files from a folder into power bi, how to select many tables instead of only one?

Thanks

I can only choose one single table from the file, how to choose more tables instead of one?

Thanks 🙂

[mgbsher]

@amitchandak 

@v-yiruan-msft 

Thanks a lot for your valuable time helping me.

Please, I've checked the links you thankfully mentioned.

I am afraid that one of the examples shown for .CSV files.

I am afraid that when I followed the steps mentioned on the other tutorial, I've got stuck at the exact same step I am struggling since the 1st post, which is choosing all tables and not only one.

Please check this images:

I choose Combine and Transform Data.

So I get this screen

I can not choose all tables from this file.

I've a lot of identical files in the same folder. 

All files are in .xlsx and not .csv.

All files have identical tables, and identical headers, only inside data that may increase or decrease.

How to choose all tables from the first file (Example file) to do all the transformation I want? How?

Thanks

-Later Edit-

If I clicked on transform data, I get this window:

Then I delete other columns:

So I keep this:

When I point mouse to this icon here:

I ended up at the exact same place:

I hope you can get my point now.

Thanks

[amitchandak]

@mgbsher , For that you should use file option like excel or csv

Or after the data is loaded, go to step before combine and add filter of files using the filter option on column and insert a step in between

[amitchandak]

@mgbsher , For that you should use file option like excel or csv

Or after the data is loaded, go to step before combine and add filter of files using the filter option on column and insert a step in between

[mgbsher]

Thanks a lot for your valuable time replying my thread.

---

@amitchandak wrote:

@mgbsher, For that you should use file option like excel or csv

---

But I've only one file for the time being, and later on I'll many identical files, so importing from an Excel file is not an option for me, as I want other future file to be loaded automatically as soon as I place them all in the folder, and just refresh the data in Power BI.

For example, files are as follow: "I've renamed files and folder, so you can see paths in plain English"

After I click load on that window, I've got the following in Power BI (To the right of the windows)

And in the right side of the page under fields, no tables of any fiels being loaded at all.

---

@amitchandak wrote:

Or after the data is loaded, go to step before combine and add filter of files using the filter option on column and insert a step in between

---

You mean to only load one single files, and do what I need first?

I am a bit confused, may you clear it a little bit more?

[v-yiruan-msft]

Hi @mgbsher ,

You can put these identical files into one same folder, and connect that folder using Folder connector. Please refer the following links to connect it in Power BI Desktop:

How to Load Data from a Folder in Power BI

FOLDER OF FILES LOADED TO POWER BI DESKTOP

Best Regards

[mgbsher]

@v-yiruan-msft 

Thanks a lot for your valuable time replying my message.

Please, if the files are in .xlsx format, and if each file has several tables and I want to import more then one table, how to do so?

Thanks

[v-yiruan-msft]

Hi  @mgbsher ,

Please review the following links, hope they can help you.

Use combine:

Load Multiple Files From The Same Folder Into Power BI

 

Combining Multiple Files from a folder using Power Query in Excel or Power BI

Import multiple files from multiple folders, and "refresh" load new file

How to process multiple files in Power BI (and optional advanced options!!)

Best Regards