Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Store old data upon refresh?

So I have a historical table that has data from years past, but then I have another table that has a live connection to download the latest daily data.    How can I structure my query to append the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, I know how to append the query to the histroical table, however, that is not my issue. Let me show an example:

 

My historical dataset is a static excel file that has daily data from January 1, 2018 to March 21, 2018. My "live" dataset is connected to a webpage that updates daily. I can setup my historical dataset to append the live dataset to the bottom so that today's data (March 22) will then be included in the historical dataset. However, tomorrow (March 23) when I go to refresh my live dataset, the historical dataset will append the March 23 data, but the March 22 data will be gone. So now my dataset will have data from January 1, 2018 - March 21, 2018 and also March 23, 2018, but March 22 will not be present.

 

Is there a way to append the daily data to a historical dataset and keep it there?

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Anonymous,

 

Basically, Power BI is an Interactive Data Visualization BI Tool. It is used to display data and store data.

 

As you want to keep the history. I'm afraid your requirement cannot be achieved.

 

Thanks,
Xi Jin.