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.
business intelligist 
“Note: HANA stores date in yyyymmdd format. There is TIP in the blog to convert this to Date data type.”
Where is this tip? If I have to convert data type to DateTime…that is not a foldable step which I assume would mean the query wouldn’t work with incremental refresh.
DataType has to be converted in the source. In this case SAP HANA