Forum Discussion

rajaaben's avatar
rajaaben
Regular Visitor
9 years ago
Solved

Combine multiple excel files into one

Hello everyone, I'm new in Power PI I have many excel files with the same headers that i need to combine into one using power bi to be able to make my dashboard. The solution that i found and with...
Need Help
  • rajaaben's avatar
    rajaaben
    9 years ago

    Hello,

     

    Thanks for your answers.

    I solved my problem using this video : https://www.youtube.com/watch?v=a7E29H5ZUmE

    i did it on PowerBi PowerQuery instead of Excel PowerQuery. while following the steps i got some _FilterDatabase lines that i had to delete.

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

rajaaben As Bhavesh mentioned that approach should work. But there is easy alternative that you can try as well. 

 

1. Import all your files into power bi desktop.

2. Go to query editor 

3. Click on Append Queries dropdown and select Append Queries as New

4. Three or more tables

 

Provided your files are of same type and same column name this will create a new query that is combination of all your queries.

  • alexbaer's avatar
    alexbaer
    Regular Visitor
    8 years ago

    I have files of the same type and column name. However, they are data sets from different locations. The locations are the names of the files. Can I make the new query include the file name?