Forum Discussion
Resolver IDaily Report Save data before refresh from sap hana
Hi.
I have a daily transaction from sap Hana :
- stemp
- value
- date
f.e:
01.10-19.10 234567,40 19.10.2021
i will store this row in another table
01.10-01.10 ....
01.10-02.10 ....
01.10-03.10 ....
....
01.10-18.10 ....
any idea?
in my daily transaction is only the row for current day
best regards
lboldrino , based on what I got so far, see like dax append can help,
there are couple of blogs around that
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
2 Replies
- amitchandak
Super User
lboldrino , based on what I got so far, see like dax append can help,
there are couple of blogs around that
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ - v-easonf-msft
Community Support
Hi, lboldrino
Powerbi is not suitable for storing and querying historical data. You can only disable the option “Include in Report Refresh” to save the results of the old query.
As mentioned in the second link provided by amitchandak , you can consider manually using the 'union' function to append the results of the old and new queries.
Best Regards,
Community Support Team _ Eason
