Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
DATATABLE
  • josef78's avatar
    josef78
    4 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

What style of data model are you talking about for the government table? Does it display a maximum of 10 rows per page of data? Is it possible to provide some relevant screenshot information?


Looking forward to your reply.


Best Regards,
Henry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Henry,

     

    I posted screencaps above, basically, a table that was given to us by the government to use for 3M EURIBOR about euro currency changes is 10 rows which update after each refresh and I was wondering is there any possibility to do it directly in PBI instead of SSAS. But as I understand josef78 it can't be done in PBI directly.

     

    Thanks for your help!