Forum Discussion

Ahsan_'s avatar
Ahsan_
Regular Visitor
2 years ago
Solved

Power BI - Folder

I have connected a folder to power bi desktop and combined all data into one table. Now I have another file with its continuation and I want it to add it to the folder and combined it with already combined data table. Is there way or ways and what's the optimal way?

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ahsan_ ,

     

    First join that data, if the two tables are similar in structure you can use append, which is appending the amount of data. If it is columns you need to use merge.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Ahsan_ 

    Your question is not clear to me,
    Can you add more details
    Once any new file is inserted in the folder, power BI automatically adds that file to the data model.



    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ahsan_ ,

     

    First join that data, if the two tables are similar in structure you can use append, which is appending the amount of data. If it is columns you need to use merge.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.