SAP HANA Direct Query for Shared Datasets

Hi Anonymous ,

To use SAP HANA, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly.

Because SAP HANA supports both DirectQuery and Import options, according to your description, I think you can use composite models to alleviate the limitations of slow query caused by dq mode.

One of its advantages is Storage mode, You can now specify which visuals query back-end data sources. Visuals that don't require a query are imported even if they're based on DirectQuery. This feature helps improve performance and reduce back- end load.

And you can also use Performance Analyzer, it helps us in understanding how the performance of the visuals can be optimized. Performance analyzer collects and displays the performance information of each visuals or DAX formula in real time.

For more details, you can read related document:

Use SAP HANA in Power BI - Power BI | Microsoft Docs

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

Use storage mode in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.