However, we are running into some barriers. When connecting to a query with stock count data per day per article, the BW layer has a difficulty with calculating the aggregate. When setting time windows beyond 1 month, the server gets out of memory.
Is there a possibility to incremental refresh SAP BW data in Power BI? It's currently not supported by the Power BI Premium functionality. However, is there a workaround? Can we dynamically load a new week and store it in historical data which is not refreshed?