Forum Discussion

fradia's avatar
fradia
Icon for Advocate I rankAdvocate 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)