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)

     

     

     

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
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)

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Does that mean with every refresh your sloution will create new sheet?