Forum Discussion
bpnelms
4 years agoNew Member
Append New Data?
This is probably a simple issue, but I haven't been able to determine a solution yet. So I have a report that automatically refreshes daily from an Oracle table on an enterprise gateway. It's basically just a snapshot of inventory balances. I'd like to keep each day's information and add in the current day with each refresh to track trends. I can easily do this in MS Access with an append query, but I'd rather be able to integrate this into the automatic Power BI daily update.
Power BI has no memory. You need to do that in the upstream system, or you need to set your data source to incremental refresh.
1 Reply
- lbendlinSuper User
Power BI has no memory. You need to do that in the upstream system, or you need to set your data source to incremental refresh.