As we know SAP HANA Connector is used to connect to SAP analytical and calc views. Sometimes HANA view might get complex and deep – it might have numerous joins, aggregations and the join might be between two fact tables (e.g. a join between Inventory and Sales tables). View might end up looking something like this…
When Power BI connects to these HANA views, especially in Direct Query mode, every click becomes expensive. And if there are multiple visuals on the page, multiple queries are executed against this view, hence impacting performance.
When creating HANA views, keep joins to a minimum and materialize the view where possible. This greatly improves Power BI performance.
business intelligist 