cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vmakhija Continued Contributor
Continued Contributor

Incremental refresh with SAP HANA view

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Incremental refresh with SAP HANA view

@vmakhija,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

Re: Incremental refresh with SAP HANA view

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vmakhija Continued Contributor
Continued Contributor

Re: Incremental refresh with SAP HANA view

@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

Microsoft
Microsoft

Re: Incremental refresh with SAP HANA view

@vmakhija,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

andaloris2
Frequent Visitor

Re: Incremental refresh with SAP HANA view

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.

Hisham
Frequent Visitor

Re: Incremental refresh with SAP HANA view

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

seems not supported with the SAP date format.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors