Forum Discussion
Feature Requests: Implement Encrypted connection to SAP HANA
When connecting to a SAP HANA instance with DirectQuery and the option "Treat HANA as a relational database" then Power BI Desktop reports that it's not possible to encrypt the connecting with Direct...
Hi, tlinnet
For your question I think you can connect to SAP HANA directly in Power BI via Direct Query connection mode.
You can also enable encryption for SAP HANA thus increasing security, you can read this document to help you: SAP HANA encryption - Power Query | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Step 1: Configure connection
Step 2: Make settinng in options
Step 3: Get data via DirectQuery
Step 4: Power BI cannot encrypt
And if you remove the tick to "Validate server certificate", but still have ticked "Encrypt connection", you get to select which table to extract, but after this, it fails with: