SAP HANA Connector – Incremental Refresh

A lot of my clients ask the following question:

“Hey I am connecting to SAP HANA using import mode. I need to bring multiple years of data into Power BI for YoY analysis. This means millions of rows of data. When I try to refresh this dataset, it takes hours to complete and in most cases it takes over 5 hours hence fails (this is a limit set on service) .”

This is a perfect scenario for incremental refresh, assuming you have premium capacity. Following blog post walks you through the set up for incremental refresh:

Note: HANA stores date in yyyymmdd format. There is TIP in the blog to convert this to Date data type.

Now this works when you have a date field in HANA view that can be used to trigger incremental refresh. When HANA view provides aggregated information there may not be a date field we can rely on to trigger incremental refresh. In this case we can use Dataflows.

I will have another post that walks through scenarios using Dataflows with SAP HANA.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s