Forum Discussion
Incremental refresh with SAP BW datasource
Hi All, I am trying to implement "Incremental Refresh" approach for Power BI dashboard based on SAP BW data source. Our SAP BW system is based on a Non-HANA database. I applied the steps gi...
I tried implementing incremental refresh manually using following steps.
1. Import data till yesterday in Master Table. Disable its "load"
2. Extract last_date from Master Table (in my case, it is yesterday's date) as a query.
3. Use last_date query to import data till today in a New Table
4. Append New Table to Master Table -> This where it throws Circular expression error
Creating reference to Master Table and appending New Table to it removes the error. However, it doesn't update the last_date query.
Any help is highly appreciated. Thanks!
GilbertQ v-xuding-msft luisDamyller pacofq nilimarodrigues