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.
Hi Ameya_Paranjape you should avoid referenced in the incremental date, It will be with incremental.