Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Set up incremental refresh for SAP BW data source on Import mode

Hi, We've built a dashboard on Power BI wherein the data source is SAP BW application server. We're importing the data and then making some transformations on it. We want to set up Incremental Refresh on the dashboard. I did create Start and End Date Parameters and also applied it on data source column but when clicking to set up Incremental Refresh the option is not enabled. Need support / guidance for the same. 

 

Thanks !

General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    According to this blog: Tips & Best Practices when using SAP BW and SAP HANA Connectors in Power BI , SAP BW should be able to set incremental refreshes.

     

    Please check if the following conditions are met.

    • The parameters name are case-sensitive (RangeStart and RangeEnd).
    • The parameters must be the Date/Time type.
    • The table must contain a date column of date/time or integer data type.
    • Check if the data source supports query folding in Power Query Editor (adding custom columns may cause query folding not to be supported).

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    According to this blog: Tips & Best Practices when using SAP BW and SAP HANA Connectors in Power BI , SAP BW should be able to set incremental refreshes.

     

    Please check if the following conditions are met.

    • The parameters name are case-sensitive (RangeStart and RangeEnd).
    • The parameters must be the Date/Time type.
    • The table must contain a date column of date/time or integer data type.
    • Check if the data source supports query folding in Power Query Editor (adding custom columns may cause query folding not to be supported).

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.