Forum Discussion

gtamir's avatar
gtamir
Post Patron
7 years ago
Solved

Get data from folder and append

Hi, I am testing get data from folder and append. I was told that some automation can be performed here. The goal is to append new file from excel every month to an exising file.   I do get data f...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi gtamir,

     

    Just need to make sure all worksheets you want to combine share the same structure, then, place the new generated Excel file into the same folder, refresh the existing query PSSales in Power BI desktop, the new data will be appended automatically.

     

    Best regards,

    Yuliana Gu

  • PattemManohar's avatar
    PattemManohar
    7 years ago

    I've done the same test and it is working fine without any issues.... Two files in the folder as below..

     

     

    Created a simple table viz. and the output is as belo...

     

     

    Now added another file in the source folder 

     

     

    Now refresh the data for the table

     

     

    The table viz. will automatically reflect the new data...

     

venug20's avatar
venug20
Resolver I
7 years ago

gtamir

 

Just have a look this scenario.... you may get some knowledge on your issue...

 

I have cereate two files and kept in one folder. uisng this folder i want to combine those two file. i follow below steps achive my goal.

 

 --- Files should be having same column name

--- and file shold be ".CSV" extention

 

 

1. go to folder connection. 

2. choose your folder.

3. then click on "edit"

4. Remove other columns, except first column.

5. click on combine files.

6. automatically show data like above screen.

 

 

9. create one more file in same folder.

10. in query editor click button "Refreh", automatically add data.

 

If it proper solution for your query, accept as answer. It may help to others...

  • gtamir's avatar
    gtamir
    Post Patron
    7 years ago

    Thanks

    After step 6 (by the way I dont see steps 7 & 8), I want to do some ETL. Let's say add a calculated column and remove another and change header names.

    Will this be applied after adding a file to the folder and REFRESH the Query?

     

    Giora