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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jongee
Frequent Visitor

Error retrieving data due to architecture mismatch

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.

4 REPLIES 4
Anonymous
Not applicable

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
Resolver II
Resolver II

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

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?

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.