Forum Discussion

bpnelms's avatar
bpnelms
New Member
4 years ago
Solved

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

  • 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.