Forum Discussion

fradia's avatar
fradia
Advocate I
9 years ago
Solved

Save old and append updated data into an additional table

Hi, I am using Power BI Desktop connected to a table in a database whose data get updated daily. The old data is overwritten with the new. I would like to store the old data so that I can use it in ...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    THERE ARE TWO STEPS TO ACHIEVE THIS.

    STEP1:

     

    CONNECT YOUR POWERBI MODEL TO DAX STUDIO(YOU NEED TO DOWNLOAD SEPARATELY)

    EXTRACT THE TABLE DATA INTO .TXT FILE USING BELOW SYNTAX

     

     EVALUATE

                TABLE NAME

     

    PUT YOUR EXTRACTED DATA INTO ONE FOLDER.

    CREATE A CONNECTION IN POWERBU DESKTOP "FROM FOLDER" OPTION.

     

    EVERYDAY REPEAT THE FIRST PROCESS WITH DAX STUDIO AND PUT YOUR FILE IN FOLDER. REFRESHING THE POWERBI DESKTOP FILE WILL PICK THE NEW ROWS( APPEND CAN ALSO BE DONE)

     

     

     

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

fradia

 

You can import first day’s data into one excel sheet from database. When in second day, you can use the existing connection to load the new data in another new sheet in the same excel file. When you want to combine these data into one table, you can get data from excel file with Power BI Desktop by selecting all sheets exist in this excel file. Then in Query Editor, just combine the imported sheets use the “Append Queries as New” function. In third day, you only need to import the new sheet into Power BI Desktop, and combine this new table to the existing Merged table.

BTW, you can vote this idea to push it supported in PBI Desktop in the future.

 

 

Best Regards,

Herbert

  • almond_boi's avatar
    almond_boi
    New Member
    7 years ago

    v-haibl-msftis there a way to have every refresh automatically load to a new sheet? So that if I do 7 refreshes, 7 new Sheets will appear with the queries content at each refresh? Thank you.