32 Bit ODBC driver with 64 Bit Power BI

[pcuezze]

I am trying to connect Power BI to an Advantage Database Server via ODBC.  The Advantage Database Server is 32 Bit.  I have connected successfully in a test environment by running

1) Power BI 32 bit on a

2) 64 Bit version of Windows Server 2016.  .

I first tried the 64 bit ADS drivers and did not have sucesss.  I then downloaded the 32 Bit ODBC drivers and was able to successfully connect.  

Now, I am moving away from the test environment and am housing PowerBI desktop on a

1) Windows 10 64 Bit machine running

2) Power BI 64 Bit.  

Again, the 64 Bit ODBC driver will not allow a connection (fails at authentication, and there is no "test" feature in the ODBC driver so I'm not 100% sure this is the problem).  I installed the 32 bit ODBC drivers but the System DSN I created does not appear as an option in Power BI's dropdown menu.  Is this normal (ie using PowerBI Desktop 64 Bit, I cannot see 32 bit ODBC drivers?)  If I revert to the 32 bit version of Power BI, will I still be able to ALSO connect to 64 Bit DSN's?  Or is there something else I'm missing?  

Also, will the 32 Bit ODBC work sucessfully with the Personal Gateway.  (thought I read somewhere that the gateway only worked with 64 bit ODBC drivers).

I'm not very technically advanced so sorry if any of that did not make sense 🙂  Thanks in advance.

patrick

[adciudad2]

I have a database on a server configured with a 32-bit ODBC, using 32-Bit Power BI Desktop
works correctly. The problem comes when I want to use the Gateway, when configuring the data set
on the web, I get this message:

Unable to connect to undefined data source.
Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [IM014] [Microsoft] [ODBC Driver Manager] The architecture of the specified DSN does not match between the driver and the application.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: dsn = BASE
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table ({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

It has a solution? or is it impossible to connect a 32 bit ODBC to the Gateway?

[Anonymous]

Hi! Did you find a solution for your 32-bit problem? I have the same error that says that the architecture does not match. Thanks in advance for a reply! 

[adciudad2]

no, we did not find the solution, we are waiting to migrate the base to 64 bits directly.

[v-frfei-msft · Accepted solution]

Hi @pcuezze ,

Both personal gateway and on-premises data gateway are 64 bit. So in this scenario, you can create a DSN within ODBC Data Sources (64 bit) under Administrative Tools, create a report use Power BI Desktop 64 bit and this ODBC data source. Then publish the report to service, enter credential for the dataset when you use personal gateway to build connection.

Besides, you can also try to create a ODBC data source under on-premises data gateway, then configure the dataset use this gateway.

Regards,

Frank