Forum Discussion

Deva002's avatar
Deva002
Frequent Visitor
10 years ago

Getting Data from SAP R/3

For one of our clients', we need to build a set of management dashboards from SAP R/3 data. How can we import data from SAP R/3? We have suggested them to use 1. SAP -> Flat File -> SSIS -> SQL -> ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi Deva002,

 

In your scenario, when you use option 1 to get data from SAP R/3, please use DirectQuery mode instead of Import mode to connect to SQL Server database. Also please update the Power BI Desktop to the latest version 2.37.4464.461.

 

To check whether the issue is caused by the large amount of data, you can get data less than 50k rows (eg: about 5k rows) to see if the same error occurs. When you get data in desktop, please use Process Monitor to trace which process is failed. Also you can check Power BI Desktop trace log files to analyze the issue.

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Deva002's avatar
Deva002
Frequent Visitor
10 years ago

v-qiuyu-msft Thanks for your inputs.

 

Yes i'm always using the latest version.

Option 1 : We planned to use directquery only. On OData Services, fetchiching 30K rows takes 10 mins and it suceeds. But in this requirement we need to fetch 1L records. Now we are cosidering a 3rd party addon called Theobald Xtract IS to fetch SAP data through SSIS. Let me know if this is a good option to go.

 

 

Thank you very Much!

-Deva

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi Deva002,

     

    As the Theobald Xtract IS is a third-party tool and I havn't used it with SSIS, I'm not able to give any comment about it. But each time you use power BI desktop to get data, I would suggest you only filter and keep useful data so that the performance should be improved. :smileyhappy:

     

    Best Regards,
    Qiuyun Yu