Direct Query report on SAP HANA

[ShivaPrasad1]

1.Is schedule refresh is really requied for SAP HANA data source connected through Direct Query?

2.Can we pass any parameters to data source to filter the data before retrival from data source?  

3. Is there any performace issues in SAP HANA server if it contains large data and we have connected it through Direct Query for our report?

[v-danhe-msft · Accepted solution]

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-premis...

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

[ShivaPrasad1]

 Thank you @v-danhe-msft. It helps.