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)

     

     

     

     

fradia's avatar
fradia
Advocate I
9 years ago

Thank you for the detailed explanation!

I followed the steps you describe and it works!

 

 

fradia's avatar
fradia
Advocate I
9 years ago

BhaveshPatel : I tried your solution and it works! Thank you!


Anonymous : I have also checked Imke Feldmann's post before writing in the forum. It seems like the right solution to this problem but I was wondering if there are also other workarounds. Thank you!

 

v-haibl-msft : Nice suggestion! I voted the idea to improve Power BI. Thanks!

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

    fradia

     

    That’s a good news you’ve got your problem solved. You could mark the right answer as solution to close this thread if convenient. :smileyhappy:

     

    Best Regards,

    Herbert