Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi There
Has anyone successfully connected SAP ECC to PowerBI?, We have managed to connect via web to the system but its not returning results as expected (We are seeing limitations as 1000 Records). Anyone had success with this or found a simply way of doing this?
Many Thanks!
Sam
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.
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.
Hi Sam! Have you tried the suggestions in this thread: https://community.fabric.microsoft.com/t5/Power-Query/How-get-data-directly-from-SAP-ECC/td-p/411305
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |