Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
lestinag
Regular Visitor

Enterprise Gateway and ODBC data source

I have set up an Enterprise Gateway.  I am having trouble adding my odbc data source to my gateway.  The ODBC data source is set up in the system DSN in my ODBC data source administrator.  My data source works in PowerBi Reports.   The database is Neteeza.   I do not have a personal gateway setup.   To my knowledge, the Enterprise Gateway version is up to date.   See the sceenshots below for all the details.

Any Ideas?

Thanks!

 

Here are the details I entered into the Gateway "New Data Source" form:

odbc1.png

 

This is the error message that it returns:

odbc3.PNG

 

Here is the Advanced Editor settings in my Power Bi Report which works fine:

odbc2.png

 

 

2 REPLIES 2
Anonymous
Not applicable

I have this issue too. DSN is x64. Any solution?

v-sihou-msft
Employee
Employee

@lestinag

 

Did you create a 32-bit DSN?

 

Power BI On-Premise Gateway is 64-bit only. If you create a 32 bit DSN, On-Premise Gateway can not find it so that it will throw above error.

 

Regards,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors