Direct Query report on SAP HANA

Hi ShivaPrasad1,

For the first issue,schedule refresh is not required. As it’s DirectQuery mode, datasets are refreshed approximately each hour or when interaction with the data occurs. You can manually adjust the refresh frequency in the Scheduled cache refresh option in the Power BI service. See: https://docs.microsoft.com/en-us/power-bi/refresh-data#live-connections-and-directquery-to-on-premises-data-sources

For the second issue, you can define variables on SAP HANA side, then you can enter desired values for these variables on Power BI side to filter data. Also you can enable the “Treat SAP HANA as a relational source” option in Power BI desktop, write the filter query when connecting to SAP HANA. See: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana

For the third issue, the performance is just related to your data source based on the Direct query mode.

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana

      https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

Regards,

Daniel He