We have a SAP-BW Production server where we are pulling some of the fields in order to build a selected powerbi report, we were not able to fetch 1 year of data directly so we tried fetching 6 months of data, the data got successfuly loaded into PowerBI, whenver we try to push for 1 Year of data the load fails, the SAP Technical person has adivsed that he cannot increase the memory as it is defined as per user session, and needs to remain as a default as it may cause issues in production.
We tried to split the data using 6 Months each in one powerbi session, but when we try to append the data in the same powerbi session the load still fails, In appending? Can we not achive the desired solution by doing this?
We even tried to decarease the batch size but we still get the same error.
We are thinking about moving the SAP-BW to Azure DW, but its a long term planning, what else can we try in order to achive to load 1 Year of data or beyond that?
