Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mgbsher
Frequent Visitor

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

Hi,

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

Thanks

 

mgbsher_0-1669924112907.png

mgbsher_2-1669924175395.png

mgbsher_3-1669924218389.png

mgbsher_4-1669924254557.png

mgbsher_5-1669924332274.png

mgbsher_6-1669924378395.png

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

Thanks 🙂

 

 

7 REPLIES 7
mgbsher
Frequent Visitor

@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:

mgbsher_0-1669979578720.png

mgbsher_1-1669979747093.png

mgbsher_2-1669979819372.png

mgbsher_3-1669980005210.png

I choose Combine and Transform Data.

So I get this screen

mgbsher_4-1669980076927.png

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:

mgbsher_5-1669980468875.png

mgbsher_6-1669980508356.png

Then I delete other columns:

mgbsher_7-1669980553364.png

So I keep this:

mgbsher_8-1669980594465.png

When I point mouse to this icon here:

mgbsher_9-1669980633867.png

I ended up at the exact same place:

mgbsher_10-1669980677728.png

I hope you can get my point now.

Thanks

 

amitchandak
Super User
Super User

@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
Super User
Super User

@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

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"

mgbsher_4-1669953807604.png

mgbsher_5-1669953836035.png

mgbsher_6-1669953887158.png

mgbsher_8-1669954128925.png

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

mgbsher_9-1669954212367.png

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?

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

yingyinr_0-1669964710387.png

yingyinr_1-1669964746767.png

FOLDER OF FILES LOADED TO POWER BI DESKTOP

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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

Hi  @mgbsher ,

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

Use combine:

Load Multiple Files From The Same Folder Into Power BI

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.