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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mail2vjj
Helper III
Helper III

Combine data from multiple excel file into one

I have run out of rows in my excel file.

 

I started a new excel file with the same table but with new data.

 

I need data from both these files in my data model.

 

How can I do that?

 

Thanks,

 

Vishesh Jain

1 ACCEPTED SOLUTION
Salvador
Responsive Resident
Responsive Resident

Hello Vishesh,

 

I've created an example that you can download from my onedrive. 

 

 

You will find images with the steps (1 to 4), a folder with both excel files, and the pbix file 😄

 

If you experience any more dificulties, please tell.

 

Regards,

Salvador.

View solution in original post

8 REPLIES 8
Salvador
Responsive Resident
Responsive Resident

Hello Visesh,

 

In order to select a folder as data source, follow these steps. By doing that, if every excel in that folder has the same structure, you wouldnt need to use append 😄2017-07-21 11_17_03-.png

 

 

Hello Salvador,

 

First of all thank you for your resoponse.

 

I tried using your method and for some reason it is not working, maybe I am not doing the write thing.

 

I am trying to combine data from these 2 files into a single table.

 

For some reason, I am unable to attach my excel files in here, so I am pasting the content here.

 

This is my first file named Book1.xlsx

CustomerSalesQuantityUnit PriceUnit CostProduct
A120.50.2Audio
A240.50.2Video
A360.50.2Camera
A450.80.2Video
B5510.5Audio
B6321Camera
B7710.5Audio
B8421Audio
B8421Camera

 

 

This is my second file named Book2.xlsx

CustomerSalesQuantityUnit PriceUnit CostProduct
A9330.2Audio
A10520.2Video
A10250.2Camera
A12620.2Video
B14720.5Audio
B14721Camera
B15530.5Audio
B16441Audio
B18921Camera
A20542Audio

 

I am tryingt to combine data from these 2 files into a single file, but the steps you suggested in order to AVOID append queries, isn't working.

 

It would be great if you could please help me out with this.

 

Thank you,

 

Vishesh Jain

Salvador
Responsive Resident
Responsive Resident

Hello Vishesh,

 

I've created an example that you can download from my onedrive. 

 

 

You will find images with the steps (1 to 4), a folder with both excel files, and the pbix file 😄

 

If you experience any more dificulties, please tell.

 

Regards,

Salvador.

Anonymous
Not applicable

Hi @Salvador,

 

I was wondering if you can also share these steps to me? I tried accessing the folder but the file is no longer available. 

Thank YOU!

Hello,

 

Please find the files here 😄

 

Regards,

Salva.

Hey Salvador,

 

Thanks for the pictures. It worked.

 

Vishesh Jain.

Greg_Deckler
Super User
Super User

Use a Folder query and put both files in the same folder.

 

Alternatively, you could use an Append query.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi smoupre,

 

Thanks for replying.

 

I did use Append queries and it did the work I wanted to do.

 

However, I still don't know how to use Folder query, so if you could please explain that.

 

Thank you,

 

Vishesh Jain

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.