How to connect ODBC through Enterprise gateway ?

[Anonymous]

Hello everyone,

Whenever I try to connect and ODBC datasource through the enterprise gateway I get the error message shown in the below screenshot.

I did install the ODBC connection !

I tried to link the same connection via personal gateway and it worked fine.

P.S:

I understand that the screenshot shows that I've used "Anonymous" authenthication method, but I've also used the "Basic" metho'd with the approporiate user name and password with no luck.

[Anonymous]

The enterprise gateway is still not working with the ODBC connection !

Could anyone find a solution ?

[v-kelly-msft]

Hi  @Anonymous ,

Check the similar thread below:

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959/page/2

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[collinq]

Hi again @Anonymous ,

What i said a moment is true....and, I just noticed this in the Power BI issue overview:

Power BI customers using PostgreSQL as a data source may see refreshes not succeed with the message "An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Engineers are investigating the issue and will provide an update soon.

[collinq]

HI @Anonymous ,

On the gateway server, have you installed the DSN for ODBC driver for PostgreSQL?  

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous]

Hi @collinq 

I did install the ODBC connection !

I tried to link the same connection via personal gateway and it worked fine.