Unable to connect PowerBi service to the Standard Gateway using the ODBC Connector

[mihaigm]

Hello World,

I'm having trouble connecting the Power Bi service to a Standard Gateway ( installed on a VM ) trough the ODBC Connector to Hana_Hep_Prod ( our SAP database ). 

Basically, I'm using a Personal Gateaway in order to update my reports that I have already pubblished on the Power Bi service. And it works just fine. But, there is a need to have also a Standard Gateway set up, so my other colleagues could use it for their reports. 

The problem is that when I'm trying to create the connection, the system returns the following error and won't let me create it:

"Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue."  

I tryied the ODBC connector on the VM and works normally, so I believe the problem is between the PowerBi Service and my VM ( where the gateway is installed ). Any idea on how to fix it???

I use the username and password of my ODBC connector for my Hana_Hep_Prod DB.

Did anyone faced this problem before??

Thank you very much in advance

Wish you a gorgeous day!

This is the error it gets:

This is the error...

[Anonymous · Accepted solution]

I tried this with SQL Server with a DSN and with a connection string and got the same error.

Please open a support ticket with Microsoft.

[Anonymous]

ODBC does have a 32-bit and 64-bit installations. If it is currently on 32-bit in VM, try creating a DSN on the 64-bit DSN Administrator and connct to that.

[mihaigm]

Thank you so much for the super fast answer!! 

I do have the 64-bit version installed on my VM...

with these drivers....