Forum Discussion

abbas_uddin's avatar
abbas_uddin
Helper I
5 years ago

SAP BW Data Load & Performance

Dear Experts,   Need you suggestions on how to handle importing large datasets from SAP BW to Power BI. Most of time it times out, dividing the queries into parts is not a good solution everytime. ...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, abbas_uddin 

 

I'd like to suggest you try using incremental refresh in PowerBI. Incremental refresh enables very large datasets in Power BI with the following benefits:

  • Refreshes are faster - Only data that has changed needs to be refreshed. For example, refresh only the last five days of a ten-year dataset.
  • Refreshes are more reliable - It's no longer necessary to maintain long-running connections to volatile source systems.
  • Resource consumption is reduced - Less data to refresh reduces overall consumption of memory and other resources.

 

For further information, please refer to the Incremental refresh in Power BI .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • abbas_uddin's avatar
    abbas_uddin
    Helper I
    5 years ago

    v-alq-msftThank you for your reply. Will this help if we have reports with input parameters?. Where user will request the data after parameters are set.

     

    Since we are thinking to implement for each company under us and users will start using for their daily reporting instead of using BEX or ERP reports.