Forum Discussion
32 Bit ODBC driver with 64 Bit Power BI
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
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?
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!
no, we did not find the solution, we are waiting to migrate the base to 64 bits directly.