Forum Discussion
Set up incremental refresh for SAP BW data source on Import mode
- 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.
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.