Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
The enterprise gateway is still not working with the ODBC connection !
Could anyone find a solution ?
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!
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
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!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq
I did install the ODBC connection !
I tried to link the same connection via personal gateway and it worked fine.