Forum Discussion
Solved
Appending To Large Static Data Set
Hello, I am trying to reduce refresh times in my report by splitting historical data from current, only refreshing current data, and then appending both datasets. This has reduced the refresh tim...
Hi Kfausch
I think what you have done till step 2 is correct. Then try using Append on table 2 where enable load should be enabled (this refers to your table that would be visible in the model or not). Just come to table 2 with Refresh disabled (static data) and then do append table 1 to this table. I believe it should work.
Also, you can avoid this by using incremental refresh as well, where probably you can store the whole data and then just refresh the latest data (1-10 days to months, quarters or years as per your requirement).
Hey Kfausch ! I wonder how you managed to resolve this problem. I have the same issue, and this approach doesn't work for me, as the table doesn't refresh at all and doesn't get data from Table 1 (Current?).