Append a table to another without deleting previous information

Hi JaviCaponte ,

When you say "randomly new data" I presume you mean it is the same data points, but for a different time period?

If so then yes, incremental refresh (IR) will just append your February data onto whatever has been accrued before it. What is retained as the 'History' partition will be based on how you set your IR up in the Service. There's also a number of other parameters/settings you can adjust that will affect what information is retained as history, at what granularity, and for how long etc. but ultimately IR will add new snapshot data onto retained historical data and store it for as long as you tell it (within reason, I believe).

I think you are correct in that you can't later download this incremental data. However, if you set up IR on a golden dataset rather than just a single report, this IR data will be available to any/all other PBI reports you want to build on it. Additionally, if you really want to be able to get the data into Excel for some reason, you can connect to the IR dataset using the 'Analyse in Excel' function in the Service and get a live connection to it from Excel.

Pete