Forum Discussion
incremental refresh in HANA view
Hi,
I am trying to use incremental refresh in HANA view and i already have cube parameters having a date field.(Sales doc Date)
But i need other date field(billing Date) to use in incremental refresh.
I have createad RangeStart and RangeEnd in the model and my dataset gets filtered in the model based on the date.
But incremental refresh is not happening in Power BI Service.
Kindly let me know if i am missing any steps.
Thanks in Advance!!
3 Replies
- amitchandak
Super User
Anonymous , in power bi service, refresh setting check for errors
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
I do not think there is anything different for HANA
https://businessintelligist.com/2019/05/14/sap-hana-connector-incremental-refresh/
Also, Troubleshoot gateway issues
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk - v-zhenbw-msft
Community Support
Hi Anonymous ,
Did the incremental refresh make an error or became a full refresh in Power BI Service?
Please check for incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd.
You can refer the following document and check whether your steps are correct.
Or you can refer the following post and blog, hope them help.
Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query
Tips & Best Practices when using SAP BW and SAP HANA Connectors in Power BI
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi Anonymous
Incremental refresh is possible in only when your data source query folding.
Other wise you may get an error as below.
Please check query folding section of the below link.