Forum Discussion
Solution for Cloud Foundry to Power BI Configuration
Authentication failures in Power BI when connecting to SAP HANA via SAP Cloud Connector typically occur because Power BI expects a direct TCP connection or a secure tunnel that supports database protocols. However, SAP Cloud Connector only supports HTTP(S) traffic it does not tunnel native HANA protocols such as SQL, JDBC, or ODBC.
If you are using SAP HANA Cloud , retrieve the host and port details from your SAP BTP Cockpit and connect using Power BI’s SAP HANA Database connector. Use Basic Authentication with your database credentials, and ensure SSL encryption is enabled in the connection settings.For on-premise SAP HANA, a direct database connection through Cloud Connector will not work.
Alternatively, for on-premise scenarios, you can expose HANA data as an OData service using XSODATA or SAP Gateway. Confirm that your Cloud Connector’s virtual-to-internal host mappings are correctly configured and active, then connect using Power BI’s OData Feed option. Authentication can be performed with user credentials or an OAuth token, depending on your setup.
For more information, refer to the official Microsoft documentation on Power Query SAP HANA database connector and DirectQuery for SAP HANA in Power BI.
Regards,
Microsoft Fabric Community Support Team.
Hey,
I already did all this steps, but some errors occurs in this. that time I stucked in that. Now I m trying by using cloud connector. I have done with next steps but at the end I got error.
1. I have add subaccount and mapping cloud to on primeses system.
2. In power Bi, I clicked on get data and select SAP HANA Database.
3. enter server and host
4. Now I got error Aunthentucation failed .
I hope you can understand exact issue that what I am facing .
If you have any further questions, please let us know. we can assist you further.
Regards
Community Support
Authentication failures in Power BI when connecting to SAP HANA via SAP Cloud Connector typically occur because Power BI expects a direct TCP connection or a secure tunnel that supports database protocols. However, SAP Cloud Connector only supports HTTP(S) traffic it does not tunnel native HANA protocols such as SQL, JDBC, or ODBC.
If you are using SAP HANA Cloud , retrieve the host and port details from your SAP BTP Cockpit and connect using Power BI’s SAP HANA Database connector. Use Basic Authentication with your database credentials, and ensure SSL encryption is enabled in the connection settings.For on-premise SAP HANA, a direct database connection through Cloud Connector will not work.
Alternatively, for on-premise scenarios, you can expose HANA data as an OData service using XSODATA or SAP Gateway. Confirm that your Cloud Connector’s virtual-to-internal host mappings are correctly configured and active, then connect using Power BI’s OData Feed option. Authentication can be performed with user credentials or an OAuth token, depending on your setup.
For more information, refer to the official Microsoft documentation on Power Query SAP HANA database connector and DirectQuery for SAP HANA in Power BI.
Regards,
Microsoft Fabric Community Support Team.