cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmgnln
Helper II
Helper II

Adding a new data source to the Enterprise Gateway Error - ODBC

Hi there,

 

I've the following situation:

- Connecting Power BI to Netsuite ODBC connector

- Connecting Power BI to csv files on a different server that were added to the enterprise gateway

- The enterprise gateway is installed on a third virtual machine  (not the same as the csv files or Power BI)

- I'm trying to add the ODBC to the gateway but I see the error below. Contacted Support they said it could be related to the csv files being on a different location than the one where the gateway is installed. But I can't move the csv files to a different location right now.

 

Has anybody seen this before? What was the solution?

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode

ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Seems like you do not have the correct ODBC driver installed on the gateway and/or have not defined the ODBC connection name.

No idea what the CSV file has to do with anything. You would not have to ODBC to a CSV file.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

Seems like you do not have the correct ODBC driver installed on the gateway and/or have not defined the ODBC connection name.

No idea what the CSV file has to do with anything. You would not have to ODBC to a CSV file.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Wow I should have asked it earlier! It was exactly that.


Thank you!

Just to make it clearer to understand for whoever is reading it next:

I didn't have the ODBC installed on the server where the gateway is installed, I only had it on my pc.

The solution was to simply installe the ODBC on the server as well.

Sometimes it's the silliest thing! Just takes another set of eyes.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.