Error retrieving data due to architecture mismatch

[jongee]

Hi

I have created a Power BI Desktop (32-Bit) report and successfully published it to Power BI online. When I try to create a data refresh using a personal gateway, I am getting the following error.

Failed to update data source credentials: We are unable to connect to the data source. Please ensure that data source is accessible.Hide details
Activity ID: 81a5c6ca-d2ff-4045-8da8-079a7bac53c2
Request ID: f51dad66-877b-2c1a-2e68-fe407ca713c8
Status code: 400
Time: Thu Mar 30 2017 09:14:25 GMT+0100 (GMT Daylight Time)
Version: 13.0.1700.1511
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
Details: ODBC: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

This error occurs regardless of the authentication method. My first guess is the Personal Gateway 64-bit? If so is there a 32-Bit version available?

If not is there anything else I can try? The connection I have is a 32-bit connection and I don't have a 64-bit version available.

Any help would be great.

[Anonymous]

There is an idea here :

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17754658-provide-full-personal-ga...

Please go vote for it so they start working on it.

Thank you

[himanshu56]

Hi @jongee

Personal gateway is 64bit - If your machine is 32bit, you will not be able to install the personal gateway. Your operating system needs to be 64bit. You will need to install a 64bit version of Windows, or install the personal gateway on a 64bit machine.

The personal gateway is supported only on 64-bit Windows operating systems.

Please have a look at the following link.

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-ga...

https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway

Thanks,

Himanshu

[jongee]

Thanks. 

I have a 64-bit OS, but the ODBC connection I am using is only 32-bit. I take it that this means I cannot refresh the data?

[himanshu56]

I guess so..

I have limited knowledge in Gateways.

For managing data sources, here is one link which you may find useful.

https://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx

Thanks,

Himanshu