Forum Discussion
Updating table without losing previous rows
Hello everyone,
I have sort of a problem, we have an access to goverment table showing EURIBOR interst rates, the downside of this table is that it only contains 10 rows, and after each refresh it keeps the 10 rows removing previous dates and adding new ones. So I was wondering is there any type of option inside PBI to update the table with new values by adding new rows and keeping older information?? And for our report we would need larger historical data and for that we would need this table to be updated with these new values by adding new rows instead of overwrighting the old values and keeping it in form of 10 rows only.
I don't have much expirience with PBI we are primarly working with Tableau but we added PBI into our group and we want to use it properly, so if I need to clarify something just say what you need me to explain.
Thanks in advance for any help!!!
after refreshbefore refresh
It is not possible in Power BI Desktop RS standaone. If you need incrementally add data to model, you need use dedicated PBI model hosted on SSAS instance (with live connection to PBI report). It allows incrementally adding data and parition processing options.
But moreover, independly if use PBI Desktop model or SSAS dedicated model, in this case I recommends use another data layer (like MSSQL DB, or any no-sql store) to persis data history, and PBI/SSAS model use only as analytic/reporting layer. PBI/SSAS prvide great query performance due to inmemory collumn store, but are not great as persisted row store.
