Forum Discussion
SAP HANA PowerBI Online error
I get the error: "Invalid connection credentials." when I publish to powerBI online.
I am using Direct Query and I have turn on the following option:
The data is visible form PowerBI desktop but is not in PowerBI Online.
PowerBI HANA Sap SAPQ Any suggestions?
Hi BryanDAX345 - we can checkt at network and firewall settings allow the Power BI Service to connect to your SAP HANA server.Allow outbound traffic on the necessary ports used by SAP HANA.Add a new data source for SAP HANA, providing the necessary connection details (server, port, credentials) at gateway configurations.SAP HANA typically requires an on-premises data gateway to bridge the connection between Power BI Online and your on-premises data source.Update firewall settings to allow connections from Power BI Service to your SAP HANA server.
Resource Links:
Power Query SAP HANA database connector - Power Query | Microsoft Learn
SAP HANA encryption - Power Query | Microsoft Learn
Configure SSL for ODBC client access to SAP HANA - Power Query | Microsoft Learn
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 Reply
- rajendraongole1
Super User
Hi BryanDAX345 - we can checkt at network and firewall settings allow the Power BI Service to connect to your SAP HANA server.Allow outbound traffic on the necessary ports used by SAP HANA.Add a new data source for SAP HANA, providing the necessary connection details (server, port, credentials) at gateway configurations.SAP HANA typically requires an on-premises data gateway to bridge the connection between Power BI Online and your on-premises data source.Update firewall settings to allow connections from Power BI Service to your SAP HANA server.
Resource Links:
Power Query SAP HANA database connector - Power Query | Microsoft Learn
SAP HANA encryption - Power Query | Microsoft Learn
Configure SSL for ODBC client access to SAP HANA - Power Query | Microsoft Learn
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!