Has anyone used HANA direct query to view HANA data in Power BI?  We are currently using it but getting a random data retrieval error that corrects upon refresh.  Have you experienced similar error?  If so, how did you resolve?

1.8k viewscircle icon1 Upvotecircle icon3 Comments
Sort by:
Director of Finance in Consumer Goods2 years ago

Yes we are using HANA direct query to view HANA data in Power BI and not experienced any error till date.

India Head and Director of Global Finance Shared Services in Hardware2 years ago

We also get such errors at times and have been able resolve these kind of problems by one or more of these approaches. 
1. Check connectivity 2. Update drivers 3. Refresh configuration 4. Check SAP HANA Logs 5. Engage HANA support team.

The frequency of retrieval errors has been 1-2 times in a quarter, and we have been able to resolve such issues mostly ourselves by applying any of first 4 approaches. We had also involved SAP HANA support team on isolated occasions when error kept coming despite refresh and stable connectivity. 

IT Director in Education2 years ago

No, as of yet we have faced no such issues