Forum Discussion
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 ...
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)
Hi
You could try loading a copy of your data and setting it not to load then appending it to your new data on refresh? i believe if the data is set not to load it will not refresh.
Mike