Incremental refresh with SAP HANA view

[vmakhija]

Hello

I just want to know if someone has implemented incremental refresh with SAP HANA View?

I am looking forward to do it in near future.. so want to inquire if there are any considerations to be done for it or any issues/limitations faced?

Regards

[Hisham]

Not able to enable the incrementatl refresh after setting up da the RangeStart and RangEnd parameters.

seems not supported with the SAP date format.

[v-yuezhe-msft]

@vmakhija,

It requires Power BI premium license to perform incremental refresh in Power BI. You can take a look at the following article about how to configure incremental refresh, if you get any issues, you can post the issues in Power BI forums.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Regards,
Lydia

[vmakhija]

@v-yuezhe-msft

Thanks for your reply.

I do have Premium...

In particular, I was looking to know how incremental refresh works with SAP HANA, if in case its different from usual incremental refresh in Power BI.

Regards

[v-yuezhe-msft · Accepted solution]

@vmakhija,

There is no special thing with SAP HANA when performing incremental refresh.

Regards,
Lydia

[Anonymous]

I disagree on this topic conclusion. From my experience, you can't use incremental refresh with SAP Hana connector, the queries are not foldables. 

However, you can connect with ODBC connector to Hana database and do it. But there is a lot of restriction coming from security, or SAP directly when you are doing this.