SAP HANA PowerBI Online error

[BryanDAX345]

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?

[rajendraongole1 · Accepted solution]

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!!