Forum Discussion
How to append data from another table upon refresh?
Anonymous
https://www.mediafire.com/file/pio5449hqd3aqbv/nchawda-append.pbix/file
Please check with the above link to get the data into Table2.
hi venal
I think you are not getting what I want, Let me explain the situation again:
Table 2 runs a API call and fetches data into it for every day. When I say it fetches the data, the old data for previous days is replaced completely with new data for current date
So Table 1 should append the data from Table 2, it should have data from previous date(coming from table 2 for previous date) and also data from current date coming from table 2.
As per your suggestion, it works only if both the tables have same data otherwise it doesn;t. The table 2 is replacing old data with new one , so while appending to table1 it replaces old data as well.
What I wanted:
Table 2 : -> Run a API call, fetch the data and format into the table for current date( which already done & works fine).
Table 1: -> Append data from Table 2 for each date and keep data for all dates. ( which I wanted to achieve - Blocked)
I hope I'm clear this time.
Without a Premium capacity where you could use the incremental load feature, there is no native way in Power BI to achieve this.
Best workaround is probably to use an R- or Python-script to export the imported data to a csv-file like described here: https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
This should not be done in power bi. Power BI is not ment to archive/store/persist adta like this.
