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.
Thank you for contacting the Microsoft Fabric Community Forum.
Power BI does not directly connect to Cloud Foundry, but you can link it through a data endpoint like an API or database. For secure integration, use OAuth 2.0 authentication by creating an access token outside of Power BI, then connect to your OData service using the Web connector. Make sure you have an OData, REST API, or database service running on Cloud Foundry that is accessible via HTTPS and has user credentials or service keys set up for authentication.
To start, create an application in SAP BTP, register it in the cockpit, and note the Client ID, Client Secret, and Token URL.
Use these credentials to request an OAuth token, for example, with Postman. Send a POST request to your token URL with the client_id, client_secret, and grant_type set to client_credentials. You will receive a bearer token in response.
Then, connect Power BI to your OData service by going to Get Data → Web in Power BI Desktop, using the Advanced option to enter your Cloud Foundry OData endpoint. Add the authorization header as: Authorization: Bearer <your_token>. This lets Power BI authenticate and securely access your data, which you can then transform and model as needed.
If you need to connect to on-premise systems, use SAP Cloud Connector to create a secure link between your on-premise SAP system and SAP BTP. Install and set up the connector, configure access control, and expose OData services from your backend with SAP Gateway. Make sure HTTPS is enabled and certificates are managed. In Power BI, connect to the OData Feed, enter your service URL, and use the correct credentials for authentication.
I hope this information is helpful. If you have any further questions, please let us know. we can assist you further.
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
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.
