Power BI Desktop: Circular Reference Error While Attempting Incremental Data Load from Oracle

I have a Power BI Desktop report connected to an Oracle database, where data is retrieved via a SQL query. The query currently uses a fixed start date and dynamically calculates the end date as today - 1. For example, the start date is 1 September 2025 and the end date is 14 December 2025.

Upon refresh, the report pulls data starting from 1 September, which—over time—significantly increases refresh duration and imposes unnecessary load on the database.

To optimize this, I attempted an incremental loading approach with the following setup:

1. Historical Data Table: Created a table named tableAHistoricalData that contains data up to 10 December 2025.
2. Reference Table: Created a reference from the historical table named tableAHistoricalDataReference.
3. Query Parameters:
   • LatesttableADateQuery: Retrieves the latest date from the historical table and uses it as the start date in the SQL query. The end date is computed as today - 1 using a DateTime function.
   • tableA_DBQuery: Executes the SQL query using the above dates to fetch the new/delta records.
4. Append Step: After retrieving new data, I attempted to append it back to the reference table. At this step, Power BI raises a circular reference error.

Request:
Could anyone please help me resolve the circular reference error or suggest a robust pattern to implement incremental data loads in Power BI Desktop for this scenario?

Additional details (if helpful):

• Source: Oracle DB
• Retrieval method: Native SQL query
• Objective: Append only new data since the latest date available in tableAHistoricalData, with end date as today - 1

Thank you in advance for your guidance.