Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Basic power bi newbie question

Hi everyone,   I have started learning Power BI two days ago and I can not understand one thing. Lets assume that there is a company, project department does  have a few people who have separate ex...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    You can merge these Excel files in Power BI but you want to be careful to keep the file name column too. Otherwise you potentially won't know where the merged rows come from (unless you have a column in your data that can do that)

     

    Use the "Folder"  connector or the "Sharepoint Folder"  connector for this (the latter is the preferred option)

     

    Also beware that what you are asking for is to merge them into one Query (not just one Dataset).

lbendlin's avatar
lbendlin
Super User
6 years ago

You can merge these Excel files in Power BI but you want to be careful to keep the file name column too. Otherwise you potentially won't know where the merged rows come from (unless you have a column in your data that can do that)

 

Use the "Folder"  connector or the "Sharepoint Folder"  connector for this (the latter is the preferred option)

 

Also beware that what you are asking for is to merge them into one Query (not just one Dataset).