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.

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

This appraoch should  defintely work. Can you please share the screenshot of the steps applied in Query editor.

The reason for this error is your headers from the csv does not match. Can you please check the headers of all csv files you are combining.