Forum Discussion
Solved
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...
Hi Ameya_Paranjape ,
For this scenario I would implement a incremental refresh that is configurable directly in Power BI:
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
This approach will handle all the scenarios of your dates and no need to implement other tables to do appends and merges.
Do not use manual append or reference tables.
Use Power BI Incremental Refresh instead:
Create parameters:
RangeStart
RangeEnd
Update the SQL query:
WHERE transaction_date >= :RangeStart
AND transaction_date < :RangeEndEnable Incremental Refresh in Model view.
Publish to Power BI Service.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | MIE