SAP HANA Connector – Incremental Refresh

No comments

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:

https://docs.microsoft.com/en-us/power-bi/service-premium-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:

WordPress.com Logo

You are commenting using your WordPress.com 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