Solution for Cloud Foundry to Power BI Configuration

Hi TriptiSodales 

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.