Forum Discussion

Mihnea's avatar
Mihnea
New Member
3 years ago
Solved

Load files from folder - different column names and number of columns

Hi all, I need to load from folder 10 different excel files, then append the same sheet name "Sheet2" from each file. The problem I have is that from file 1 to file 10 the column names inside "Sheet...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    here you find your solution from How to Power BI

    COMBINE FROM FOLDER in Power BI | What to do when new columns don't show?!

    https://www.youtube.com/watch?v=JAw4rrpc7vk

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

here you find your solution from How to Power BI

COMBINE FROM FOLDER in Power BI | What to do when new columns don't show?!

https://www.youtube.com/watch?v=JAw4rrpc7vk

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

Mihnea's avatar
Mihnea
New Member
3 years ago

Thanks, it seems like it's what I'm looking for. I'll give it a test. 

Thanks!