Forum Discussion
Update existing table and keep all data in report
Hi all Experts 😀
my problem ist the following one: I want to scrap some data from a table, e. g. website etc., and add these rows to the existing table in Power Bi. So for example I open my report on Monday and refrersh the data of table 1.
Monday:
| date | Text |
| 02.01.2022 | house |
| 01.01.2022 | mouse |
On Thuesday (03.01.2022) there is a new new rows in the existing table (dog). Now my table at the report should be like that:
| date | Text |
| 03.01.2022 | dog |
| 02.01.2022 | house |
| 01.01.2022 | mouse |
But for my report I need all rows not only the e.g. first two ones. (That is the way I have at least understand how incremental loading is working, if it is wrong please correct me). Is there a possibility to do this in that way? I can't load the whole table on the second day, because after a few days the last rows in the source are overwritten. But I need the hole table over the time...
after few days:
| date | Text |
| 09.02.2022 | rabbit |
| 08.02.2022 | snake |
| 07.02.2022 | bird |
(The workaround by Power automate is possible, but maybe there is another option direct in Power BI without python, script or something like that 😥)
Thanks a lot
Do5779
3 Replies
- lbendlinSuper User
Power BI has no memory, and no concept of global variables/adding rows. You need to do that in the upstream system.
- lbendlinSuper User
Upstream means before Power BI. This could be the data source itself. Or some intermediate system like Power Automate that can implement the required process.