We are trying to extract data from our Sap By Design ERP system via PowerBI to analyse and combine some of the reports to get more out of the system.
The problem we have is whenever we try to download the data it will only show us the first 1000 rows, if you scroll to the bottom of the list it will load more data at 50 rows at a time however as some of the tables are 10+ times that size that isn't very efficient.
Does anyone know if there is a way to increase the size of the visible data or is that a limit of either SAP or oData? we've imported SQL tables in the past that are of the size we would be working on with no problems but we're constantly hitting brick walls. I've tried everything I can think of including putting in a $top limit of 2000 however it will always load upto 1000.
Has anyone got any pointers?