Hi @SAMBWILLANS ,
I hope the link shared by @tlauronen will be helpful for you. The issue you are experiencing with the 1000 record limit is a common scenario that many users encounter when integrating SAP ECC with Power BI. The limit you are experiencing may be due to default settings in Power BI when extracting data from an external source, such as SAP ECC. However, there are ways to bypass these limitations to get more records.
- To increase the row limit in Power BI Desktop, you can adjust the row limit by going to File > Options and settings > Data source settings, then navigating to the SAP ECC connection you are using and adjusting the limit.
- Consider switching to DirectQuery mode, which allows Power BI to maintain a live connection to SAP ECC data without having to import and store the data in Power BI. This helps overcome record count limitations.
- Make sure that the connector settings in Power BI for SAP ECC are configured correctly. Sometimes, specific configurations or restrictions are set in the connector itself. Check the connector documentation for any settings that might affect data retrieval restrictions.
For more information about connecting to SAP ECC and troubleshooting common problems, you may find the following links helpful:
Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn
DirectQuery and SAP Business Warehouse (BW) in Power BI - Power BI | Microsoft Learn
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
