Forum Discussion
SAP HANA DirectQuery lack of performance
Hello,
I have a report based on a HANA view which contains a lot of data.
I used DirectQuery to handle this.
The report is very slow at displaying data and when refreshing data while using slicers.
People are working on the HANA view to make it faster.
Do you know how I can tune performance with Power BI or have some best practices?
Thanks
3 Replies
v-yuta-msftCommunity Support
Anonymous ,
I would suggest you refer to doc below about how to improve performance of direct query.
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for these links. I had the opportunity to read them earlier and they provided some answers to the lack of performance.
However, are there any tips on importing a HANA view in DirectQuery mode?I continue to look for additional resources about optimization with DirectQuery. If anyone has any information about this, I'm interested.
Thank you,